Change the Order of a Report Parameter (Report Builder and SSRS)
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 is determined by the order of the parameters in the Report Data pane.
Note
You can create and modify report definitions (.rdl) 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. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To change the order of report parameters
In the Report Data pane, expand the Parameters node.
Click a parameter and use the up and down arrow buttons on the Report Data pane toolbar to move the parameter higher or lower in the list. The following image shows the Report Data pane in Report Builder.
.png "Report Data Pane")
See Also
Tasks
Add Cascading Parameters to a Report (Report Builder and SSRS)
Tutorial: Add a Parameter to Your Report (Report Builder)
Concepts
Report Parameters (Report Builder and Report Designer)
Report Builder Help for Dialog Boxes, Panes, and Wizards
Add Dataset Filters, Data Region Filters, and Group Filters (Report Builder and SSRS)