TechNet
Export (0) Print
Expand All

Change the Order of a Report Parameter (Report Builder and SSRS)

 

Applies To: SQL Server 2016

Change the order of report parameters when you have a dependent parameter that is listed before the parameter it is dependent on. Parameter order is important when you have cascading parameters, or when you want to show users the default value for one parameter before they choose values for other parameters. A dependent report parameter contains a reference, in either its default values query or valid values query, to a query parameter that points to a report parameter that is after it in the parameter list in the Report Data pane.

The order that you see parameters display on the report viewer toolbar when you run the report, is determined by the order of the parameters in the Report Data pane and the location of the parameters in the custom parameters pane. For more information, see Customize the Parameters Pane in a Report (Report Builder)

System_CAPS_ICON_note.jpg Note


You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

You can change the order of report parameters by doing either of the following:

  • Click a parameter in the Report Data pane, and use the up and down arrow buttons to move the parameter higher or lower in the list, as shown in the following image. When you change the order of the parameter in the Report Data pane, the location of the parameter in the parameters pane is changed.

    Change the order of the parameters in the Report Data pane

  • In the parameters pane, drag the parameter to a new column or row in the pane. When you change the location of the parameter in the pane, the parameter order changes in the Report Data pane. For more information about moving parameters in the pane, see Customize the Parameters Pane in a Report (Report Builder).

Report Parameters (Report Builder and Report Designer)
Report Builder Help for Dialog Boxes, Panes, and Wizards
Add Cascading Parameters to a Report (Report Builder and SSRS)
Tutorial: Add a Parameter to Your Report (Report Builder)
Add Dataset Filters, Data Region Filters, and Group Filters (Report Builder and SSRS)
Parameters Collection References (Report Builder and SSRS)

Community Additions

ADD
Show:
© 2016 Microsoft