Dataset Properties Dialog Box, Parameters

Select Parameters on the Dataset Properties dialog box to add, change, and delete query parameters, including query parameters that link to report parameters.

Whenever the query is changed on the query tab, the query command is parsed. For each query parameter that is identified, a report parameter with an identical case-sensitive name is created. By default, the query parameter is automatically added to the query parameter list and linked to the corresponding report parameter.

If there are dependencies for the default values of one report parameter on another report parameter that is linked to a query parameter, the order of report parameters (as they appear in the Report Parameters Properties dialog box) is important. Report parameters later in the list can refer to report parameters earlier in the list. For more information about report parameters, see Parameters (Report Builder 3.0 and SSRS).

Options

  • Add
    Add a new parameter to the list.

  • Delete
    Remove the selected parameter from the list.

  • Parameter name
    Type the name of a query parameter that you added to the dataset on the Query tab of the Dataset Properties dialog box.

  • Parameter value
    Enter a value for 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.

  • Up arrow
    Move the selected parameter up in the list.

  • Down arrow
    Move the selected parameter down in the list.