Adding a condition

There are two ways to define multiple filter conditions. You can select a column and define a filter, then select the next column and define a filter, and so on. Or you can use the Advanced Filter dialog box, as shown in Figure 7-10. You can use Advanced Filter to modify or delete existing filter conditions.

For example, using the former method, you can define two filters, the first on the SALES OFFICE column, the second on the PRODUCTLINE column.

When you use this method to define multiple filters, Interactive Viewer constructs the following filter expression:

SALES OFFICE = San Francisco

and PRODUCTLINE = Vintage Cars

This filter returns only data rows that meet both conditions. Sometimes, you want to create a filter that returns data rows when either condition is true, or you want to create a more complex filter. To accomplish either task, you can use the Advanced Filter dialog box, as shown in Figure 7-10.

As the example shows, Advanced Filter provides more options for defining a filter with multiple conditions. It also displays all the filter conditions defined for the report table, or chart element.

Figure 7-10

Adding a filter condition

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

BIRT iHub 2