How to: Associate a Query Parameter with a Report Parameter (Report Designer)

To associate a query parameter with a report parameter

  1. In Data view, from Dataset, select the dataset for which to edit the parameter and click the edit (...) button.

  2. On the Parameters tab, do the following:

    • In Name, type the query parameter as it exists in the query.


      Parameter names are automatically populated based on the parameters in the query.

    • In Value, type or select an expression that evaluates to the value to pass to the query parameter.

  3. Repeat step 2 for additional query parameters.


    You are not limited to report parameters as values for a query parameter. You can use any expression that evaluates to a value for the parameter value.

See Also


Defining Report Datasets
Working with Table Data Regions
Working with Matrix Data Regions
Working with List Data Regions
Report Designer How-to Topics
Using Parameters to Control Report Data

Other Resources

Report Designer F1 Help
Working with Parameters in Reporting Services
Tutorial: Adding Parameters to a Basic Tabular Report
Tutorial: Advanced Features Using Parameters

Help and Information

Getting SQL Server 2005 Assistance