Export (0) Print
Expand All
Expand Minimize
2 out of 15 rated this helpful - Rate this topic

Report Parameters (Report Designer)

SQL Server 2005

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.