Re: Questions on Oracle Reports 2.5

YKen wrote:
>
> Hi,
>
> Is there a way to limit the list of possible values in the DESTYPE system
> parameter when it appear in the parameter form, say PRINTER/PREVIEW only ?
>
> Best Regards,
> Ken

There is an indirect way to do this that works just fine...

Create a USER PARAMETER of your choice (e.g. USER_DESTYPE) and have the data selection of the user parameter be a static list of values of your choice, your above example would have "Printer" and "Preview" listed. Remove the DESTYPE system parameter from the parameter form and replace it with your created USER PARAMETER.

Finally, to have your created parameter referenced in the running of the report add the following piece of code to the AFTER_PARAMETER_FORM trigger:

  :DESTYPE := :USER_DESTYPE;
  RETURN (TRUE); The following code will overwrite the value of DESTYPE with the value selected from your list in USER_DESTYPE. This will indirectly limit the DESTYPE parameter to the specific set of values you want.

Hope this helps...

-- 
 ___ ___ ___ ___ ___ ____   ___ ___ ___ _  _  _   _  _ ___ ___  ___
| _ \   | _ \ __| _ \   _| | __| __| _ \ \| |/ \ | \| |   \ __|/ __/
|  _/ | | _ < _||  _/| |   | _|| _||  _/    | _ \|    | | | _| \__ \
|_|_\___|___/___|_|_\|_|   |_| |___|_|_\_|\_|/ \_\_|\_|___/___|/___/

********************************************************************
        Robert Fernandes - LLNL AIS Dept

        Phone:  (510) 423-1397     Fax:  (510) 423-5882
        Email:  rfernand_at_llnl.gov - or - fernandes6_at_llnl.gov
********************************************************************