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 property settings for the report parameter. 2 For Display type, choose Combo Box, List Box, or Radio Button. 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 Selection values table and Import Values button in Edit Parameter 3 In List of value, 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 12‑13. Figure 12‑13 Import Values 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 Select the values to import. o To import all values, choose the double right arrow (>>) button. 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 Imported values in Edit Parameter 5 To add values manually, complete the following steps for each value: 1 Next to the Selection 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 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 Creating a new value 3 Choose OK. The new value is added to the Selection values table. 6 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 values table. 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 Specifying the text to display 3 Choose OK to save the change. The item is updated in the Selection 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: 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. 2 In Sort direction, select either Ascending or Descending. 9 Choose OK to save your changes to the report parameter.
This procedure assumes that you already created at least one report parameter in your report design.