Operation Manual

Building Queries
Query filters and prompts
18
362 Crystal Reports User’s Guide
By default, the Query Panel combines the filters with the And operator.
2. Leave the And operator.
Or
Double-click the And operator to change the operator to Or.
For an example of each operator and the difference between them, see
“Using And or Or to combine query filters” on page 363.
u
To combine advanced filters with other filters or prompts
1. Create each filter.
For step-by-step information on how to create advanced filters, see
“Creating advanced query filters” on page 358. For information on how to
create simple query filters, see “Creating query filters” on page 355.
By default, the Query Panel combines the filters with the And operator.
2. You can leave the And operator or double-click the operator to change it
to Or.
For an example of each operator and the difference between them, see
“Using And or Or to combine query filters” on page 363.
3. To nest a filter under another filter or prompt, select the filter you want to
nest and drag it onto the filter you want to group it with.
The Query Panel groups the two filters and nests the grouped filters
beneath the other filter(s).
4. Double-click the And/Or operator to change the operator if necessary.
When you run the query or refresh the report data, Crystal Reports filters
the data according to the query filters you defined.