Export (0) Print
Expand All
Expand Minimize

Report Parameter Properties Dialog Box, Available Values

Select Available Values on the Report Parameters dialog box to choose a set of values that are available for the report parameter and how users select them.

None

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

Specify values

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

Add

Appears when you choose the Specify values option. Click to add a new 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.

Label

Appears when you choose the Specify values option. Type text that is displayed to the user as an available report parameter. When the user clicks the label in the list, the value specified in Value is used in the report parameter. Click the Expression (fx) button to edit the expression.

Value

Appears when you choose the Specify values option. Type a value that can be used as a report parameter value. Click the Expression (fx) button to edit the expression.

Get values from a query

Retrieve a 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 Creating and Adding Datasets (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.

Label field

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

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

Community Additions

ADD
Show:
© 2014 Microsoft