Designing reports using BIRT Studio : Filtering data : Prompting for filter values at run time : Creating a static filter parameter : How to create a static filter parameter at the data set level
 
How to create a static 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, and lay out the report.
3 In BIRT Studio, in Available Data, choose Switch Filter Pane.
4 Filter Pane appears, as shown in Figure 5‑27. Choose Add to define a filter condition.
Figure 5‑27 Filter Pane
5 Advanced Filter appears, as shown in Figure 5‑28. On Advanced Filter, in Filter By, select a column from the drop‑down list.
Figure 5‑28 Defining a static filter parameter in Advanced Filter
6 In Condition, select an operator from the drop‑down list.
7 Select Prompt Text, then type the text to display. Edit Parameter is highlighted, and Is Required appears selected.
8 Choose Edit Parameter. In Edit Parameter, create the parameter condition as follows:
*To create a static filter parameter using a list of values, complete steps 1 to 9 in How to create a static filter parameter with a list of values.
*To create a static filter parameter using a text box complete steps 1 to 6 in How to create a static filter parameter at the report table level.
Choose OK.
Figure 5‑29 displays the completed filter parameter condition. The selected default value appears in Default Value, as shown in Figure 5‑29.
Figure 5‑29 Advanced Filter displaying the static filter parameter condition
9 Choose Add Condition. The condition appears in Conditions, as shown in Figure 5‑29.
10 Choose Add Filter. The static filter parameter condition appears in Filters.
Choose OK. Filter Pane displays the specified condition.
Test the prompt in BIRT Studio by choosing Parameter. Parameters displays the prompt, as shown in Figure 5‑30. The default value specified in the example condition is USA.
Figure 5‑30 Parameters displaying that static parameter condition