Dataset (Parameters Tab, Report Designer)

Use the Parameters tab of the Dataset dialog box to define values for query parameters. The parameters list is automatically populated, but you use this tab to add, edit, and delete query parameters.

The order of parameters is important. When you define a parameter for the query, it is automatically added to the list of report parameters. Parameters later in the list can refer to parameters earlier in the list and be used for drillthrough reports. For more information about report parameters, see Report Parameters (Report Designer) and Working with Parameters in Reporting Services.

Options

• Name
  Type a parameter from the query.

• Value
  Type a value to be passed to the query parameter. This can be a static value or an expression that refers to an object within the report, but it cannot refer to any report items or fields. By default, Value contains an expression that points to a report parameter created automatically by Report Designer when the query is updated.

• Up
  Click the Up arrow to move the selected parameter up in the list.

• Down
  Click the Down arrow to move the selected parameter down in the list.

• Delete
  Click the Delete button to remove the selected parameter from the list.

See Also

Reference

Report Designer F1 Help
Dataset (Data Options Tab, Report Designer)
Dataset (Fields Tab, Report Designer)
Dataset (Filters Tab, Report Designer)
Dataset (Query Tab, Report Designer)

Other Resources

Defining Report Datasets
Using Expressions in Reporting Services
Tutorial: Adding Parameters to a Basic Tabular Report
Tutorial: Advanced Features Using Parameters
Using Parameters to Control Report Data

Help and Information

Getting SQL Server 2005 Assistance

Change History