A script-enabled browser is required for this page to function properly.

Creating a list of values (LOV) for a parameter

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:

  1. In the Object Navigator, expand the Data Model node, then the User Parameters node.

  2. Double-click the User Parameter Properties icon (the properties icon) for the parameter for which you want to create a LOV to display the Property Inspector.

  3. Under the Parameter node, double-click the List of Values property value field to display the Parameter List of Values dialog box.

  4. Select the type of list that you want to create:

  5. 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.

  6. 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:

  7. Click OK.

See also

Creating a user parameter

Using a pre-defined system parameter