The Parameter List of Values dialog box enables you to define a list of values for a parameter. You can create a static list of values or use values from the database. Select the type of list you want to create (Static Values or SELECT Statement) and the settings in the dialog will change as appropriate.
This dialog box contains:
Static Values |
Indicates that you want to manually enter values to populate the list of values for the parameter. If you select this option, you must you type a value in the Value field, then click Add. Repeat for each value you want in the list. To remove value(s), select them in the list, then click Remove. |
SELECT Statement |
Indicates that you want to type a SELECT statement to populate the list of values for the parameter. If you select this option, you must enter a SELECT statement in SQL Query Statement area. |
Restrict List to Predetermined Values |
Indicates whether a value for the parameter must be in the list of values. For example, if you check Restrict List to Predetermined Values and the Initial Value does not match a value in the list of values, an error will be generated. Similarly, if you set a value for the parameter on the command line or in a command script and it does not match a value in the list of values, an error will be generated when the report is run. If you check Restrict List to Predetermined Values, a list of values will appear in the Runtime Parameter Form. If you do not check it, a combo box will appear (that is, you can enter values as well as select from the list). |
Hide First Column |
Indicates whether the first column in your SELECT list should be displayed in the parameter's list of values. This setting is useful for hiding values that the user does not know about or are confidential. |
Value |
Is a value that will be added to the static list of values for the parameter when you click Add. |
Copyright © 1984, 2005, Oracle. All rights reserved.