How to create a dynamic filter parameter at the data set level
1 Create a new report by selecting a template containing a data set, an information object, or a data object.
2 Select the data fields to insert in the report.
3 In BIRT Studio, in Available Data, choose Switch Filter Pane.
4 Filter Pane appears. Choose Add to define a filter condition. Advanced Filter appears.
5 On Advanced Filter, select Dynamic, as shown in
Figure 5‑35.
Figure 5‑35 Advanced Filter displaying the dynamic filter parameter
6 In Filter By, select a column from the drop‑down list.
In Advanced Filter, Prompt Text displays the text you entered earlier.
8 Choose Add Filter. The dynamic filter parameter condition appears in Filters, as shown in
Figure 5‑35. Choose OK. Filter Pane displays the condition.
9 To test the prompt in BIRT Studio choose Parameter. Parameters displays the prompt, as shown in
Figure 5‑36. The default operator specified in the example condition is In, and the default value is USA.
Figure 5‑36 Parameters displaying the dynamic prompt
When working with a dynamic prompt for a column containing numeric data that uses the Match or Not Match operators, if you use the value 1 as the string value to match you must use double quotation marks (" ") to enclose the value. Type the value as "1" in the text box or combo box, so that BIRT Studio evaluates it accurately as a literal string. If you use other values such as 2, 3, and so on, you do not need to enclose them in double quotation marks.