User`s guide

For step-by-step information on how to create filters and prompts, see Creating query filters or
Building prompts.
By default, the Query Panel combines the filters and prompts with the And operator. You can leave
the And operator or change the operator to Or. See Using And or Or to combine query filters.
2.
If necessary, change the operator to Or by double-clicking the And operator.
Or now displays as the operator. The prompts appear when you click OK, or when you refresh the
report data.
16.5.4 Using And or Or to combine query filters
This table explains the difference between the And and the Or operators.
SelectExampleRetrieve this data
And
Customers who ordered sup-
plies in Q1 and in Q2 (the data
you retrieve will include: cus-
tomers who placed orders in
both Q1 and Q2).
Data true for both filters.
Or
Customers who ordered sup-
plies 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).
Data true for any one of the fil-
ters.
16.5.5 Quick reference to query filter operators
2012-03-14351
Building Queries