Add parameters to a report

Modifying your report can be done at anytime after report creation. Adding new parameters allows you to specify additional criteria that you would like as part of the report. In the following example we add a filter for the connection name.

To add a parameter

1. In Microsoft Visual Studio, navigate to the Report Data pane > Parameters.

   

2. Right-click the Parameters folder and select Add Parameter.

   The Report Parameter Properties dialog box appears.

   

3. In the Report Parameters dialog box:

   1. In the Name field, enter a name for the parameter.

   2. In the Prompt field, enter a prompt for the parameter.

   3. Select OK.

   The Report parameters dialog box closes and your new parameter will appear under the Parameters folder in the Report Data pane.

   

4. Expand the Datasets folder, and then right-click your dataset and select Dataset Properties.

   The Dataset Properties dialog box appears.

   

5. Select the Parameters tab.

   

6. Select Add.

   Additional fields will appear.

   

7. Fill in the Parameter Name and Parameter Value fields.

8. Select the Query tab.

   The Query field will be populated with your new parameter.

   

9. Select OK.

   The Dataset Properties dialog box closes.

10. Select the Preview tab for your report.

    

11. Use your new parameter to manipulate the data in the table. In this example, we are applying a filter for the connection name.

    

12. Select View Report.