Introduction to SSRS Parameters

Report parameters can be used to control report data, restrict data returned to the report, connect related reports together, and vary report presentation. It is important to understand how parameters and dataset queries are related and how to include parameters in expressions.

After you publish a report, you can manage parameters independently from the report definition (for example, when developing custom subscriptions).

When you view a report through the Report Manager URL, a toolbar displays each parameter so that you can specify values.

Parameters Pane

The report viewer toolbar displays a prompt and default value for each parameter. Parameter layout on the toolbar is formatted automatically. The order is determined by the order that parameters display in the Report Data pane. You can modify the order. The parameters, with the exception of @Hierarchy, are displayed as filters in AMT.

@FromDate, @Todate Parameters

These parameters have a DateTime data type and display a date picker control both in AMT and Report Manager.

@Site parameter

This parameter has a Text data type. @Site has an available values list, so valid values display in a list for you to choose values. @Site is multivalued, so a Select All option displays that enables you to clear all and select all values in the list.

@DateRange, @Hierarchy, @AddFilters

These parameters are only populated when the report is run from within AMT - you can ignore them otherwise.

Parameters Button

In the Report Builder preview, on the Ribbon, click Parameters.

View Report Button

On the Report Viewer toolbar, click View Report to run the report after you enter parameter values. If all parameters have default values specified, the report runs automatically when viewed in Report Manager.