Parameterised Report

To create a report with parameters, proceed as follows.

In this example a parameter will be added to filter the report by an ISA Location specified by the user when the report is run.

• In the Field List window, right-click on the Parameters section, and in the displayed menu, click Add Parameter.

  

  Repeat this action to create the second parameter.

• Set the properties of the parameter as required. For example:

  

  Note:
  Every time a report is previewed, the user will be asked to enter the values of any parameters. The following instructions explain how to use these values to filter a report's data.

• Select the report (by clicking anywhere on the blank space of the report), and in the Property Grid, locate the Filter String property and click the ellipsis. The FilterString Editor is displayed.

  In this window, define the required expressions for the parameters. Construct an expression where a data field (for example, ISA Location) is compared with the create parameter. To access parameters, click the icon on the right until it turns into a question mark. For example:

  

  Note:
  Make sure that the report's Request Parameters property is set to Yes. Otherwise, the parameters will not be requested when the report is previewed, and a blank report will be the result.

The parameter filtered report is now ready. To view the results, switch to the Preview tab, and in the Parameters section, define the required values and click Submit.