Results 1 to 4 of 4

Thread: How do you make a parameter read only

  1. #1
    Member
    Join Date
    Apr 2005
    Location
    Windsor, ON Canada
    Posts
    222

    How do you make a parameter read only

    How do I go about setting a parameter as read only. I have a FACULTY parameter that I want to set a default value and make it as read only so that when the clients run their reports they cannot change this parm. Want to do this so I can have one report with different faculties running the selection criteria but do not want them to be able to set the faculty to another value that is not their faculty. Want to have the parm but want to have the parm as read only so I have cost center security. How do I go about doing this. I came across this in Crystal 2008. Does anyone know how to set it up to make it work?

    Show on (Viewer) Panel
    Choose whether the parameter will display on the parameter panel and whether it will be editable or read-only.
    Do not show: The parameter is not visible on the panel. Users must refresh the report to change the parameter's values.
    Editable: Users can view and change the parameter's values on the panel.
    Read only: Users can view the parameter's values on the panel, but cannot change them.
    By default, the program sets this field to Editable.

    Cathy Wilbur
    cwilbur@uwindsor.ca
    OW B7334 ERP 8.0 SP24 Updt 1; Unix RS6000; Oracle 11; Create!Form Server 7x/CTIS (Rel 7.01.400); Crystal 2011
    Createform Output we make use of in projects using following file types as input: CSV, PDF, TXT, XML

  2. #2
    Member
    Join Date
    Apr 2005
    Location
    Windsor, ON Canada
    Posts
    222

    Re: How do you make a parameter read only

    Got it working. Had to set up a drop down list with one value and define the field as READ ONLY and do not allow any custom values. To roll this out to different departments will have to change the single drop down value and the default value. Not the best solution but I do not want to embed the Faculty parameter in hidden selection criteria or I would have to create multiple versions of the report. See attachment.

    Now have to figure out how to get default value to be selected if person does not pick anything.
    Attached Images Attached Images
    Cathy Wilbur
    cwilbur@uwindsor.ca
    OW B7334 ERP 8.0 SP24 Updt 1; Unix RS6000; Oracle 11; Create!Form Server 7x/CTIS (Rel 7.01.400); Crystal 2011
    Createform Output we make use of in projects using following file types as input: CSV, PDF, TXT, XML

  3. #3
    Member
    Join Date
    May 2001
    Location
    Florence, AL
    Posts
    63
    There is a simple solution to you last problem. Test the variable in a formula field starting with "BeforeReadingRecords;" Place this formula in the report header section and hide it. Then if value = default set value = desired value; Not quite the right syntax but you get the idea.

    Hope that works for you.
    8.11 SP1 Tools 8.98.3.2
    I5 - 550 V6R1

  4. #4
    The most is very great, thanks for sharing awesome ideas may be it helpful for us.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.