Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Add or Remove a Parameter (Report Builder 1.0)

A parameter is a variable that sets the scope of the data returned when a report is run. You can provide a default value, or the person running the report can select a value or set of values. To add a parameter to your report, you need to create a filter clause and then specify the Prompt option.

To add a parameter to a report

  1. With your report open and displayed in Report Builder design mode, on the Report menu, click Filter.

  2. Drag the entity or field that you want to use for your parameter to the Filter area.

    A filter clause is created.

  3. Right-click the entity or field name and select Prompt.

    Optionally, to specify a default, type or select a criteria value.

  4. Click OK.

    Now, when you want to view the contents of the report, you need to type or select a value from the prompt displayed in the toolbar at the top of the report.

To remove a parameter to a report

  1. With your report open and displayed in Report Builder design mode, on the Report menu, click Filter.

  2. Right-click the entity or field name in the Filter area and select Prompt again to clear the option.

    NoteNote

    When you clear the Prompt option, the filter clause remains in the filter area. If you want to remove the entire filter clause, select Remove Condition instead.

  3. Click OK.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.