How to specify static report parameter values
This procedure assumes that you already created a report parameter.
1 In Data Explorer, expand Report Parameters, then double-click the report parameter to edit.
Edit Parameter displays the property settings for the report parameter.
2 For Display type, choose Combo Box, List Box, or Radio Button.
Edit Parameter displays the Selection list values table and the Import Values button, as shown in
Figure 13‑14. The Selection list values table is where you specify the values to display in the list box, combo box, or radio buttons.
Figure 13‑14 Selection values table and Import Values button in Edit Parameter
3 In Selection list values, use the default value, Static.
4 To import values from a data set field, perform the following tasks:
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 13‑15.
Figure 13‑15 Import Values
2 In Select Data Set, choose the data set that returns the field values to display in the list box, combo box, or radio buttons. Typically, this data set is one that you create specifically to populate the parameter’s list of values.
3 In Select Column, choose the field that contains the values to use.
4 Select the values to import.
To import all values, choose the double right arrow (>>) button.
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 list values table, as shown in
Figure 13‑16.
Figure 13‑16 Imported values in Edit Parameter
5 To provide descriptive labels for users to choose, other than the value in Value, perform the following steps:
1 Double-click the item in the Selection list values table.
2 In Edit Selection Choice, in Display Text, type the text that you want to display to the user.
Figure 13‑17 shows an example of displaying United Kingdom for the value, UK.
Figure 13‑17 Specifying the text to display
3 Choose OK to save the change. The Selection values table displays the updated value.
6 To add values manually, complete the following steps for each value:
1 Next to the Selection list values table, choose New.
2 In New Selection Choice:
1 In Display Text, type the text prompt to display to the user.
2 In Value, type the value to pass to the SQL query or the filter condition.
Figure 13‑18 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 13‑18 Creating a new value
3 Choose OK. The new value is added to the Selection list values table.
7 To designate a value as the default value, select the value, then choose Set as Default.
8 To specify how the values should be sorted when presented to the user:
1 Under Sort, in Sort by, select one of the following values:
Select None, the default, to display the values in natural order, which is the order of items in the Value column of the Selection list values table.
Select Display Text to display in ascending or descending order the values in the Display Text column.
Select Value Column to display in ascending or descending order the values in the Value column.
2 In Sort direction, select either Ascending or Descending.
9 Choose OK to save your changes to the report parameter.
