Export (0) Print
Expand All
Expand Minimize

Report Parameter Properties Dialog Box, Default Values (Report Builder 3.0)

Select Default Values on the Report Parameters dialog box to choose a default value for the selected parameter from a query or from a static list.

None

By default, this option is selected before you choose the report parameter value.

Specify values

Choose a value or a set of values for the report parameter.

Add

Appears when you choose the Specify values option. Click to add a default report parameter value.

Delete

Appears when you choose the Specify values option. Click to delete a report parameter value.

Up arrow

Click to move the available value up in the list.

Down arrow

Click to move the available value down in the list.

Value

Appears when you choose the Specify values option. Type a value that can be used as a default report parameter value or click the Expression (fx) button to edit the expression. You can specify Globals and Common Functions as default values, such as "=Today()". You cannot specify a field name as a default value. The default value data type must match the data type of the parameter.

Get values from a query

Retrieve a default value or set of values from a data source.

Dataset

Appears when you choose the Get values from a query option. Choose a dataset from which to retrieve a value or set of values for the report parameter. For more information about how to define a dataset, see Adding Data to a Report (Report Builder 3.0 and SSRS).

Value field

Appears when you choose the Get values from a query option. Choose a field from which to obtain the value or set of values. The available fields are retrieved from a list of field names in the dataset.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft