Share via


How to: Change the Order of a Report Parameter (Reporting Services)

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. Parameter order is important when you have cascading or when you want to show users the default value for one parameter before they choose values for other parameters.

To change the order of report parameters

  • In the Report Data pane, expand the Parameters node. Click the 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.

    Note

    If the Report Data pane is not visible, click Report Data on the View menu.

See Also

Tasks

How to: Add Cascading Parameters to a Report (Reporting Services)

How to: Associate a Query Parameter with a Report Parameter

How to: Add, Change, or Delete Default Values for a Report Parameter (Reporting Services)

How to: Add, Change, or Delete a Report Parameter (Reporting Services)

Concepts

Adding Parameters to Your Report

Tutorial: Adding Parameters to a Report

Filtering Data in a Report

Using Parameters Collection References in Expressions (Reporting Services)

Working with Report Data How-to Topics

Other Resources

Report Designer F1 Help

Tutorials (Reporting Services)