Operation Manual

Building Queries
Query filters and prompts
18
364 Crystal Reports User’s Guide
u To remove a query filter
• Drag the filter you want to remove and drop it onto the left-hand pane.
The filter is removed from the query definition and no longer appears on
the Query Filters pane.
Related topics:
• “Creating query filters” on page 355
• “Building prompts” on page 356
Quick reference to query filter operators
The following table will help you select the operator you need to define a
query filter.
Values to retrieve Example Select Filter created
Values equal to a
value you specify.
Retrieve data for the US
only.
Equal to <Country> Equal to US
Values different from
a value you specify.
Retrieve data for all quarters
except Q4.
Different from <Quarter> Different
from Q4
Values greater than
a value you specify.
Retrieve data for customers
aged over 60.
Greater than <Customer Age>
Greater than 60
Values greater than
or equal to a value
you specify.
Retrieve data for revenue
starting from $1.5M upward.
Greater than or
equal to
<Revenue> Greater
than or equal to
1500000
Values lower than a
value you specify.
Retrieve data for exam
grades below 40.
Less than <Exam Grade> Less
than 40
Values lower than or
equal to a value you
specify.
Retrieve customers whose
age is 30 or less.
Less than or
equal to
<Age> Less than or
equal to 30
Values between two
values you specify
that includes those
two values.
Retrieve the weeks starting
at week 25 and finishing at
36 (including week 25 and
week 36).
Between <Weeks> Between 25
and 36
Values outside the
range of two values
you specify.
Retrieve all the weeks of the
year, except for weeks 25
through 36 (week 25 and
week 36 are not included).
Not between <Weeks> Not Between
25 and 36
Values that are the
same as several
values you specify.
Retrieve data for only the
following countries: the US,
Japan, and the UK.
In list <Country> In list 'US;
Japan; UK'