Specifying which prompt dialog you want to display to your users

If you have specified that you want to prompt the user to specify a value when using the query you can specify which dialog appears so that they can enter the required value. There are two options: Simple List and Grid Layout.

If you select Simple List then the following dialog appears to the user when they run the query:

If you select Grid Layout, the following dialog appears to the user when they run the query:

To run a query that has a prompt:

1. On the shortcut bar, click the relevant query icon.
   The Criteria Prompts dialog appears.
2. Select the criteria for which you need to specify a value, then in the Value box, type or select the required value.

Alternatively, leave the value blank to return all values without that criteria. If the Condition is Is Equal To, type the required value, then click Verify. If the Condition is Is One Of, click Pick Values. All the values you add to the list will be returned.

3. Repeat for all the required criteria, then click Go.

If one of the conditions is a category, then you can click the drop down list to see the various levels of category. Select the required category from the tree that appears in the list.