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

To associate a query parameter with a report parameter

In Data view, from Dataset, select the dataset for which to edit the parameter and click the edit (...) button.
On the Parameters tab, do the following:
- In Name, type the query parameter as it exists in the query.
  
  Note
  
  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.
Repeat step 2 for additional query parameters.

Note

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.