Creating multiple filter parameters

You can specify multiple static filter parameters, dynamic filter parameters, or a combination of both types. You create multiple filter parameters on Advanced Filter. The following section describes how to define multiple filter parameters in a BIRT design.

How to create multiple filter parameters

1 Select and right‑click the first column for which you want to create a prompt. Choose Filter➛Filter. Filter appears. The selected column appears in Filter By.

2 Select Static or Dynamic.

To create a static filter parameter, complete steps 1 to 9 in How to create a static filter parameter with a list of values.

To create a dynamic filter parameter, complete steps 1 to 7 in How to create a dynamic filter parameter at the report table level.

3 On Filter, choose Advanced Filter.

4 On Advanced Filter, choose Add Condition. The filter parameter condition you previously specified appears in the Conditions area in Advanced Filter.

5 To define the next condition, in Advanced Filter, complete the following steps:

1 In Filter, select Static or Dynamic.

2 In Filter By, select a column from the drop‑down list.

3 If necessary, select Prompt Text and type the display text for the prompt.

4 If the report contains aggregate data, do one of the following:

To recalculate aggregate data values across the filtered data rows, select Recalculate Totals, if necessary.

To calculate aggregate data for the unfiltered data, deselect Recalculate Totals.

5 Choose Edit Parameter.

If you selected Static in step 1, complete steps 1 to 9 in How to create a static filter parameter with a list of values.

If you selected Dynamic in step 1, complete steps 1 to 7 in How to create a dynamic filter parameter at the report table level.

6 In Advanced Filter, choose Add Condition.

7 Choose Add Filter.

6 To define additional filter parameters, in Advanced Filter, repeat step 5. Choose OK. The example in Figure 11‑24 shows Advanced Filter displaying three filter parameter conditions.

Figure 11‑24 Defining multiple filter parameters in Advanced Filter

7 To test the prompt in Report Studio, choose Data➛Parameters. Parameters displays the prompt with the three defined conditions for which the user can supply values, as shown in Figure 11‑25. The first condition is a static filter parameter, and the remaining two conditions are dynamic filter parameters.

Figure 11‑25 Specifying multiple filter parameter values