Previous Next

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
Edit Parameter displays the property settings for the report parameter.
2
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 16-14 Selection values field and Import Values button in Edit Parameter

Figure 12‑12
3
4
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 16-15 Import Values

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.
4

o

o

 

Choose OK. Edit Parameter displays the imported values in the Selection values table, as shown in Figure 12‑14.

Figure 16-16 Imported values in Edit Parameter

Figure 12‑14
5
1
2
1
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
3
6
1
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
3
7
8
1
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
o
2
9

(c) Copyright Actuate Corporation 2009