Adding parameters (prompts) to a Report Builder report

You easily can add basic parameters to a Report Builder report using the Filter dialog. For example, to let the user choose which year to view sales data for, add an Order Year filter condition to your report filter, then, instead of specifying a value, click the "Order Year" label on the left side of the condition and choose "Prompt" from the menu. This will create a corresponding report parameter that will supply the value when the report is run. If you also specify a value in the filter dialog, this value will be used as the default parameter value.