Using Filter Operators

When you use Active Reports to set rules to determine what data from a report to show or highlight, you use operators to describe how to make the comparison.

Comparisons take the following form: Fieldname Operator Criteria.

For operators that make comparisons that are larger, smaller, or between with text information, CRS sorts in alphabetical order.

The table below shows the operators you can use.

Operator	Description	Example
Equals	Shows information that matches what you specify.	Mode Equals Bank Draft
Not equal	Shows information that does not match what you specify.	Mode Not equal Bank Draft
Greater than	Shows information larger than, but not equal to, the value specified.	Payment Date Greater than 01/01/12
Greater than or equal to	Shows information the same as or larger than the value dispersive.	Payment Date Greater than or equal to 01/01/12
Less than	Shows information smaller than but not the same as the value specified.	Payment Date Less than 01/31/12
Less than or equal to	Shows information smaller than or the same as the value specified.	Payment Date Less than or equal to 01/31/12
Between	Shows information between the two values specified, including those values.	Payment Amount Between $10.00 and $19.99
Contains	Shows information that contains the value specified, but doesn't pay attention to upper or lower case.	Last Name Contains Ande
Contains (match case)	Shows information that contains the value and matches the case you used.	Last Name Contains (match case) Ande
Omits	Hides information that contains the values you specify, but doesn't pay attention to upper or lower case.	Last Name Omits Ande
Omits (match case)	Hides information that contains the value you specify and matches the case you use.	Last Name Omits (match case) Ande