Creating a filter

When you create a filter, you define a condition that specifies which data rows to include in the report. A filter condition is an If expression that must evaluate to true in order to include a data row. For example:

If the order total is greater than 10000

If the sales office is San Francisco

If the order date is between 4/1/2010 and 6/30/2010

Figure 5-1 shows an example of a condition defined in Filter. As the illustration shows, Filter helps you define the condition by breaking it down to the following parts:

The column to evaluate, such as Total.

The comparison operator that specifies the type of comparison test, such as Greater Than. For information about all the operators, see Functions and operators.

The value to which all values in the column are compared, such as 10000.

Figure 5-1

Filter displaying a filter condition

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2