Operation Manual

Building Queries

Query filters and prompts

Crystal Reports User’s Guide 357

To create a prompt

1. Select the object you want to apply a prompt on and drag it to the Query

Filters pane.

For example, if you want to allow users to specify the geographical region

for the report, drag the Region field to the Query Filters pane.

The Filter Editor appears. By default, the name of the filter is the name of

the filtered object.

2. Select an operator from the list.

See “Quick reference to query filter operators” on page 364.

Note: You cannot use the following operators for prompts: Is null, Is not

null, Both, and Except.

3. Under Operator type, select Prompt.

The Prompt text field shows the default message.

4. If you want to change the default message, edit it to word a question.

For example, you might ask “Which region do you want to see data for?”

5. Check Select only from list if you want your prompt to display a list of

values from which users can select value(s).

Use this option to prevent users from typing a value that might not exist in

the database.

6. Click OK to confirm the prompt.

The prompt appears at each report refresh.