Share via


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

Report Designer F1 Help

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

Help and Information

Getting SQL Server 2005 Assistance