How to: Add or Remove a Parameter (Report Builder)
New: 17 July 2006
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
With your report open and displayed in Report Builder design mode, on the Report menu, click Filter.
Drag the entity or field that you want to use for your parameter to the Filter area.
A filter clause is created.
Right-click the entity or field name and select Prompt.
Optionally, to specify a default, type or select a criteria value.
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
With your report open and displayed in Report Builder design mode, on the Report menu, click Filter.
Right-click the entity or field name in the Filter area and select Prompt again to clear the option.
Note
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.
Click OK.
See Also
Concepts
Working with Parameters (Report Builder)
Working with Filters (Report Builder)
Working with Data (Report Builder)
Other Resources
Filter Data Dialog Box (Report Builder)