When you create a new BIRT design, Report Studio provides the Table Builder wizard to help you select data fields and create a data set filter. Once these data fields appear in the BIRT design, you can no longer invoke Table Builder. Instead, you use Advanced Filter to create or modify a data set level filter condition. When you select Filter➛Slicer Filter from the context menu of the report table handle, the filter condition you specify using Advanced Filter is evaluated at the data set level.
How to create a data set filter
1 In Report Studio, in Available Data, choose Filter.
2 Advanced Filter appears, as shown in Figure 10‑5. To create a filter condition, complete the following steps:
1 In Filter By, select a column from the drop‑down list.
2 In Condition, select an operator. Depending on the operator you choose, one or two value fields appear. The example in Figure 10‑5 shows the selection of the operator Between, and two corresponding value fields.
3 In Date From and Date To, do one of the following:
Type a value.
Choose Select Values, then select a value from the list of values that appears.
Use the calendar tool to select a date.
Select No Value to choose a null value.
4 Choose Add Condition. Conditions displays the new condition, as shown in Figure 10‑5.
Figure 10‑5 Specifying a data set filter in Table Builder
5 Choose Validate to verify the syntax of the new condition.
6 Choose Add Filter. Filters displays the condition.
Choose OK. Report Studio displays data fields that meet the filter condition in the BIRT design.
How to modify a data set filter
To modify a data set filter condition, complete the following steps:
1 In Available Data, select Filter. Advanced Filter appears.
2 In the Filters area, select the condition, then choose Edit.
3 Modify the condition by changing the values in Filter By, Condition, or Value.
To delete a filter condition, in the Filters area of Advanced Filter, select a filter and select Delete. Then, select a condition and select Delete. Choose OK. Verify that any remaining filter conditions display the expected results.
Type a value.