Previous Topic  Next Topic

Applying Parameters

When running a web report with parameters, Report Server displays a dialog box for you to specify the parameter values. The runtime parameter dynamically controls your report result. After the report is opened in Web Report Studio, you can change the parameter values in the Parameters panel. You can also use parameter control or parameter form control to change the parameter values for the report.

The Parameters panel is available when the current web report uses parameters. It lists all the parameters used by the report.

Edit the values according to your requirement and then select Apply to make the report run with the specified parameter values.

The way to specify a parameter value varies according to the type and properties of the parameter. Here are several ways you can use to specify parameter values:

• In the parameter value combo box, select the down arrow and then select the required value from the drop-down list.

  To ensure performance, by default at most 500 values are listed. When the listed values are just a part of the values of the parameter, after you scroll down to the bottom of the list, more values (500 at most) will be automatically loaded into the drop-down list.

  For a parameter that is bound with a column, you can make use of the Sort button to display the values in the ascending or descending order for easy look-up, and search for the required values conveniently in the search box. To cancel the search, clear the input text or select in the search box.

  When a parameter's values are encrypted, the value drop-down list will be disabled. In this case, if the Hide Parameter Value check box is available, you can clear it to enable the drop-down list to view and select the required value.

• Type the value manually in the parameter value text box if the parameter allows for type-in values but not multiple values.

• Click in the parameter value combo box to specify multiple values if the parameter allows for multiple values.
• Select or clear the check box to specify a Yes/No value.
• Select the Calendar icon to specify a date and time value.

See the usages below about the other options in the panel:

• Save as default
  Saves current parameter values as the default values for the report. Not available when Enable Setting Default Parameter Values For Web Report the corresponding report type is unselected in the server profile.
• Re-enable Parameter Screen
  When this option is unselected, the next time the report runs via operation in the Logi Report Server console, it will use the default parameter values directly without popping up the Enter Parameter Values dialog box. However, if the default values cannot completely match the report parameters, the dialog box will still be displayed. You can select it to show the Enter Parameter Values dialog box again after it has been hidden.

  This option is not available when Enable Hiding Initial Parameter Dialog For Web Report is unselected in the server profile.

  The Save as default and Re-enable Parameter Screen options are user-report level settings, that is to say, they take effect when both the same user and report are matched. This also applies to admin users, and therefore admin users cannot customize the settings for all users.

• Reset
  Resets the parameter values. This button varies according to different situations:
  • When Save as default is available in the panel, the button contains a text part and a triangle icon. You can choose to reset the values to either of the following by selecting the triangle. If you select the text part of the button directly, the values will be reset to the original default values.
    • Original Default Values
      The default values defined in the parameters' definition.
    • User Defined Default Values
      Your last-time saved default values.
  • When Save as default is unavailable in the panel, the button contains only the text part. Selecting it will reset the values to the original default values.

Specifying Multiple Values for a Parameter

For a parameter that allows for multiple values (the parameter's Allow Multiple Values property is true), you can specify one or more values to it.

1. Click in the value combo box of the parameter. Report Server displays the Enter Values dialog box.

   

2. If the parameter's Enable the "All Values" Option property is true, the All Values check box is available and by default it is selected. It means to apply all values to the parameter. When the parameter is inserted as a field into a report and All Values is selected as the value, the field will show the string "All". If you do not want to apply all values to the parameter, deselect the All Values check box and then specify the desired values as shown in the following steps.
3. Select the required values in the Available Values box and select to add them to the Selected Values box; to add all the listed values, select .

   To ensure performance, by default at most 500 values are listed in the Available Values box. When the listed values are just a part of the values of the parameter, after you scroll down to the bottom of the list, more values (500 at most) will be automatically loaded into the list. You can make use of the Sort button to display the values in the ascending or descending order for easy look-up, and the Search button to search for the required values conveniently. To cancel the search and close the search box, select in it.

   If some added values are not wanted, select them in the Selected Values box and select to remove them; to remove all added values, select .

4. When the parameter's Allow Type-in of Value property is true, the Enter Values text box is available. You can type a value manually and select next to add it to the Selected Values box. When the parameter is bound with a column, but the display column is different from the bound column, make sure the value you type is that of the bound column. If the parameter is of the Date, DateTime, or Time type, you can also select the Calendar icon to specify a date and time value.
5. Select OK to select the specified values for the parameter.

Previous Topic  Next Topic