HP Intelligent Management Center Standard Software Platform - Manual (Page 473)

Filter created Select Example
Values to re-
trieve
Differ-
ent from Q4
Different from
Retrieve data for
all quarters ex-
cept Q4. Values different
from a value you
specify.
Greater than 60
Greater than
Retrieve data for
customers aged
over 60. Values greater
than a value you
specify.
Greater than or
equal to 1500000
Greater than or
equal to
Retrieve data for
revenue starting
from $1.5M up-
ward.
Values greater
than or equal to a
value you specify.
Less than 40
Less than
Retrieve data for
exam grades be-
low 40. Values lower than
a value you speci-
fy.
Less than
or equal to 30 Less than or
equal to
Retrieve cus-
tomers whose
age is 30 or less. Values lower than
or equal to a val-
ue you specify.
Be-
tween 25 and 36
Between
Retrieve the
weeks starting at
week 25 and fin-
ishing at 36 (in-
cluding week 25
and week 36).
Values between
two values you
specify that in-
cludes those two
values.
Crystal Reports 2008 SP3 User's Guide 473
18 Building Queries
Query filters and prompts