Operation Manual

Building Queries
Query filters and prompts
18
Crystal Reports User’s Guide 363
Related topics:
• “Editing and removing query filters” on page 363
Using And or Or to combine query filters
This table explains the difference between the And and the Or operators.
Related topics:
• “Combining query filters and prompts” on page 357
Editing and removing query filters
You can edit and remove filters on queries.
u
To edit a query filter
1. Double-click the filter you want to edit.
The Filter Editor appears.
2. Change the definition of the filter in the Filter Editor.
For information on how to define filters, see “Creating query filters” on
page 355.
Note: If you are editing an advanced filter, you can remove objects
defined in the filter by dragging them off the filter onto the left-hand pane,
or you can add objects to the filter by dragging objects from the left-hand
pane onto the advanced filter. For more information, see “Creating
advanced query filters” on page 358.
3. Click OK to confirm your changes.
The modified query appears in the Query Filters pane.
Retrieve this data Example Select
Data true for both
filters.
Customers who ordered supplies in Q1 and
in Q2 (the data you retrieve will include:
customers who placed orders in both Q1
and Q2).
And
Data true for any one of
the filters.
Customers who ordered supplies in: Q1 or
Q2 (the data you retrieve will include:
customers who placed orders in Q1only;
customers who placed orders only in Q2,
and; customers who placed orders in both
Q1 and Q2).
Or