Add Parameters to a Report

Parameters can be used to filter the data in a report or specify that will be used to calculate other values (in the latter case, use calculated fields).

To add parameters and filter a report based on their s, follow the steps below:

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

   

2. Repeat this action to create the second parameter.

3. In the Field List, select the first parameter, and in the Property Grid, set its (Name) to FromDate, Description to From: and Parameter Type to Date Time.

4. For the second parameter, set these properties as shown in the following image.

   

   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.

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

   

6. In this window, define the required expressions for the parameters.

   Note: Make sure that the report's Request Parameters property is set to Yes (which is the default setting). 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.

7. To view the results, switch to the Preview tab, and in the Parameters section, define the required values and click Submit.