Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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