Export (0) Print
Expand All
Expand Minimize

How to: Add, Edit, or Delete a Report Parameter (Report Designer)

  1. On the Report menu, click Report Parameters.

    ms159266.note(en-US,SQL.90).gifNote:
    If the Report menu is not available, click within the report design area.

  2. Select the report parameter, or click Add to add a new parameter.

  3. In Name, type the name of the parameter.

  4. In Data type, select the data type for the parameter value.

  5. In Prompt, type the text that appears next to the parameter text box when the user runs the report.

  6. If the parameter can contain a null value, select Allow null value. If it can contain a blank value, select Allow blank value.

  7. For Available values, select Non-queried to provide a static list of values from which the user can choose a value, or select From query to provide a dynamic list from a query.

    • If Non-queried is selected, type a list of labels and values. The Label property contains the text that is displayed to the user; Value is the value that is passed to the report server for the parameter.
    • If From query is selected, select a dataset, a value field to map to the parameter value, and a label field to display to the user.
      ms159266.note(en-US,SQL.90).gifNote:
      The dataset used for this option is usually created specifically for the report parameter. For information about datasets, see Defining Report Datasets.

  8. For Default values, select Non-queried to provide a static default value, or select From query to provide a dynamic default value from a query. To provide no default value, select None.

    • If Non-queried is selected, type a value or expression to use for the default value.
    • If From query is selected, select a dataset and a value field to map to the default parameter value.
    • None is selected, the value used for the default value is null.
      ms159266.note(en-US,SQL.90).gifNote:
      The dataset used for this option is usually created specifically for the report parameter. For information about datasets, see Defining Report Datasets.

  1. On the Report menu, click Report Parameters.

    ms159266.note(en-US,SQL.90).gifNote:
    If the Report menu is not available, click within the report design area.

  2. Select the report parameter that you want to delete, and then click Remove.

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

Community Additions

ADD
Show:
© 2014 Microsoft