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.

7	Choose Edit Parameter. In Edit Parameter, create the parameter condition by completing step 5 in How to create a dynamic filter parameter at the report table level.

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.

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

BIRT iHub 2