Creating a filter

To create a filter, you define a condition specifying which data rows to display. A filter condition is an If expression that must evaluate to True for a data row to be included. The following list shows examples of possible filter conditions:

If the credit limit is greater than 100000

If the sales office is San Francisco

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

Figure 7-4 shows an example of a filter condition. When defining a filter condition, you can break it down into the following parts, as shown in Figure 7-4:

The column to evaluate, such as credit limit

The comparison operator specifying the type of comparison test, such as Equal To

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

Figure 7-4

Creating a filter

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

BIRT iHub 2