Define Query Parameters Dialog Box


Applies To: SQL Server 2016

Use the Define Query Parameters dialog box to specify parameter values when you run a query in a query designer at design time to see sample data. Query parameters filter data on the data source and help to limit the amount of data that a report processes. These values are not saved in the report definition.

Parameter Name
Type the name of the query parameter that you want to use.

Parameter Value
Type the value that you want to use for the query parameter.

SQL Server Connection Type (SSRS)
Report Parameters (Report Builder and Report Designer)
Reporting Services Query Designers

Community Additions