Report Parameters (Report Designer)
Use the Report Parameters dialog box to define parameters for a report. For more information about these options, see Creating Report Parameters and Setting Report Parameter Properties.
Options
- Parameters
Use this list to view and manage report parameters. To move a parameter within the list, click the parameter, and then click the up or down arrow.
- Add
Choose this option to create a new report parameter.
- Remove
Click a parameter, and then choose this option to delete the parameter.
- Name
Type a name for the parameter. The name must be an identifier that is compliant with the Common Language Specification (CLS).
- Data type
Select the data type of the parameter.
- Prompt
Type the text that is to be displayed next to the parameter text box when the report runs.
- Hidden
Select this option if the parameter value should not appear on the report. Although hidden parameters do not appear on a report, they can be set in other ways (for example, in subscriptions and through URLs).
- Internal
Select this option if the parameter cannot be changed at run time. On a published report, no visual evidence is provided to indicate that this parameter exists.
- Multi-value
Select this option to allow multiple selections in a parameter drop-down list.
- Allow null value
Select this option if the value for the parameter can be null.
- Allow blank value
Select this option if the value of the parameter can be an empty string.
- Available values
Select an option to display available values from a query or from a static list.
- Non-queried
Select this option to enter a static list of parameter values from which the user can choose. If you select this option, a list in which you can type values and labels appears.
- From query
Select From query to provide a dynamic list of parameter values from which the user can choose. This list is obtained from a data source. If you select From query, three fields appear in which you can define query information.
- Label
Appears only when Non-queried is selected. Type a label that is displayed to the user. When the user clicks the label in the list, the value specified in Value is retained for the parameter.
- Value
Appears only when Non-queried is selected. Type a value that will be retained for the parameter.
- Dataset
Appears only when From query is selected. Select a dataset from which to retrieve the list of parameters. You define datasets using the Data view. For more information, see Defining Report Datasets.
- Value field
Appears only when From query is selected. Select a field from which to obtain a list of available values, for example, EmployeeID. The available fields are retrieved from a list of column or field names in the dataset.
- Label field
Appears only when From query is selected. Select a field from which to obtain a list of labels to display to the user for the values, for example, EmployeeName. The available fields are retrieved from a list of column or field names in the dataset.
- Default values
Select an option to display default values from a query or from a static value.
- Non-queried
Select Non-queried to enter a static default value or a set of default values for the parameter. If you select Non-queried, a text box appears in which you type a value or set of values. Click the expression (fx) button to edit the expression
- From query
Select From query to retrieve the default value or set of default values from a data source. If you select From query, two fields appear in which you define query information.
- Dataset
Appears only when From query is selected. Select a dataset from which to retrieve a default value or a set of default values for the parameter. You define datasets using the Data view. For more information, see Defining Report Datasets.
- Value field
Appears only when From query is selected. Select a field from which to obtain the default value or set of default values. The available fields are retrieved from a list of column or field names in the dataset. The value from the first row in the dataset is used for the default value.
- None
Select None if you do not want to provide a default value for the parameter.
See Also
Reference
Other Resources
Working with Parameters in Reporting Services
Working with Parameters in Reporting Services
Using Expressions in Reporting Services
Tutorial: Adding Parameters to a Basic Tabular Report
Tutorial: Advanced Features Using Parameters