Acquiring a Query Parameter from User Input
By default, when you add a parameter in a query condition, the user is prompted to enter the value at runtime. (To use another field of the query to provide an aggregate value for the right side of the condition, see Acquiring a Query Parameter from a Query Field.)
To customize user prompting when setting the parameter value by user input, follow the steps below:
1. Open the desired query for editing. (Double-click the query in the Asset panel.)

2. Click the 'Parameters' button in the toolbar. This opens the 'Query Variable Definition' dialog box. The 'Variable List' panel at the top displays any query parameters that have been specified in the query condition.
3. Select the desired variable in the 'Variable List' panel.
4. Click the 'User Variable' button (if not already selected).

5. Click 'Set Selection List' to open the 'Selection List' dialog box. (The button's label is displayed in green if the selected parameter already has a list associated.)
6. To enter a fixed set of labels/values for the parameter, follow the steps below:
a. Click the List tab.
b. Click 'Add' to add a new label/value pair.
c. Enter the desired 'Label' and 'Value'. (The 'Label' text is displayed to the user in the interface element; the corresponding 'Value' is assigned to the parameter.)

7. To acquire parameter labels/values from a different query at runtime, follow these steps:
Note: The query is used to prompt the user for input. If you want a query to automatically set the parameter value (without user input) see Acquiring a Query Parameter from a Query Field.
a. Click the Query tab.
b. Select the query that contains the label/value pairs.
The data in the first column of the query are used as the parameter values; the data in the second column of the query are used as the labels. (Query conditions can reference other parameters if those parameters possess default values.)

8. (Optional) Select 'Allow multiple selections' to permit the user to select multiple values for the parameter.
To remove values associated with a parameter, click the 'Clear' button in the 'Selection List' dialog box.
9. Click 'OK' to close the 'Selection List' dialog box.
10. Make the following optional selections in the 'Query Variable Definition' dialog box, if desired:

a. Select 'As customization parameter' to expose the parameter as a customization parameter. Customization parameters are displayed when the user clicks the 'Customize' button on the report toolbar. (See Report Toolbar in End User.)
b. Select 'Prompt User' if the user should be automatically prompted to enter a value for this parameter. (Disable this option for parameters set by script and drill-down reports.)
c. Select 'Sort Values' if you want the list to be sorted alphabetically.
d. Enter text in the 'Tooltip' field to display when the user hovers the mouse over the corresponding parameter control on the input form.
11. Click 'OK' to close the 'Query Variable Definition' dialog box.
| << 3.5.2 Query Parameters | © 1996-2013 InetSoft Technology Corporation (v11.4) | Acquiring a Query Parameter from a Query Field >> |