Tip: If you define a parameter in a template, you must apply the template to a report in order to select that parameter for the Runtime Parameter Form.
To create a LOV for a parameter:
In the Object Navigator, expand the Data Model node, then the User Parameters node.
Double-click
(the properties icon) for the parameter for which you want to create a LOV
to display the Property Inspector.
Under the Parameter node, double-click the List of Values property value field to display the Parameter List of Values dialog box.
Select the type of list that you want to create:
For Static Values, type a value in the Value text box and click Add. Repeat for each value you want to add. (Click Remove to delete items from the list)
For SELECT Statement, type a query to populate the list of values. You can select more than one column to display in the LOV, where the first column contains the value to be assigned to the parameter. The LOV displays columns in the order specified in the query.
If you want the parameter value to be restricted to only those in the LOV, select the Restrict List to Predetermined Values check box. To display a combo box that allows users to edit values or type a different value in the Runtime Parameter Form, clear the check box.
If you do not want the first column (which contains the parameter value) of your query displayed in the LOV, select the Hide First Column check box. If there is no need to preserve the confidentiality of the first column, clear the check box.
Cautions:
If you send the report output to an HTML file, either from Reports Builder or running it in your Web browser, the value of the first column will be visible in the HTML source, even if Hide First Column is selected.
If you run the report from a Web browser and the list of values is unrestricted, the HTML Parameter Form will display a text field instead of a combo box, and a list of static values that you can copy and paste into the text field. In this case, the first column will always be shown in the Parameter Form, even if Hide First Column is selected.
Click OK.
Using a pre-defined system parameter
Copyright © 1984, 2005, Oracle. All rights reserved.