How to specify static report parameter values for users to select
This procedure assumes that you already created at least one report parameter in your report design.
1 In Data Explorer, expand Report Parameters, then choose the report parameter to edit.Edit Parameter displays the Selection values table and the Import Values button, as shown in Figure 12‑12. The Selection values table is where you specify the values to display in the list box, combo box, or radio buttons.
Figure 12‑12
1 Choose Import Values. Import Values displays the first data set in the report and the values of the first field in the data set, as shown in Figure 12‑13.
Figure 12‑13
2 In Select Data Set, choose the data set that has the field values you want to display in the list box, combo box, or radio buttons. Typically, this data set is one that you create specifically for populating the parameter’s list of values.
3 In Select Column, choose the field that contains the values to use. Import Values displays the values for the selected field.
o To import a particular value, select the value, and choose the right arrow (>) button.Choose OK. Edit Parameter displays the imported values in the Selection values table, as shown in Figure 12‑14.
Figure 12‑14
2 In Value, type the value to pass to the SQL query or the filter condition. Figure 12‑15 shows an example of a user-defined value that appears as All Customers on the Enter Parameter dialog when the user runs the report. When the user selects this value, % is passed to the SQL query.
Figure 12‑15
6 To provide descriptive labels for users to choose, other than the value in Value, perform the following steps:
2 On Edit Selection Choice, in Display Text, type the text that you want to display to the user. Figure 12‑16 shows an example of displaying United Kingdom instead of UK.
Figure 12‑16
o Select None, the default, to display the values in natural order, which is the order of items in the Value column of the Selection values table.
o Select Display Text to display in ascending or descending order the values in the Display Text column.
o Select Value Column to display in ascending or descending order the values in the Value column.
(c) Copyright Actuate Corporation 2009 |