Filter By displays the column on which to apply the filter.
2 Select Static as the type of filter, if necessary.
3 In Condition, select the comparison test, or operator, to apply to the selected column. Depending on the operator you select, Filter displays one or two Value fields, or a completed filter condition.
4 If you select an operator that requires a comparison value, you can specify the value in one of the following ways:
In Value, type the value.
To select from a list of values, choose Select Values. A list of values appears. Select a value from the list. Figure 10‑3 shows the selection of Boston from the list of available sales office values.
Figure 10‑3 Specifying comparison values for a filter condition
If the list of values is long, type a value in Filter Text and choose Find. If found, Report Studio displays this value in the list. When you select the value, it appears in Value.
To specify null values, select No Value.
If you are filtering a detail table containing aggregate data, or a summary table, you can recalculate the aggregate data values for the retrieved data rows by accepting the default selection of Recalculate Totals. To calculate totals for all the data rows in the report table, deselect Recalculate Totals.
5 Choose OK. The filter takes effect. In cases where the sample data in the BIRT design does not meet the filter condition, the BIRT design does not display any data. Report Studio displays the message in Figure 10‑4. Always test a filter by running and viewing the generated BIRT design in Actuate Viewer.
Figure 10‑4 The message displayed when the sample data in the BIRT design does not meet the filter condition
In Value, type the value.
