How to: Sort Data (Report Builder)
When creating the report, you can set a sort order on the data contained within each group of the report. When viewing a tabular report in run mode, you can perform a sort on a field within each group by using the up and down arrows beside each column heading.
To sort data
In the Report Builder window, click Sort and Group on the Report menu.
Note
Alternatively, click the Sort and Group button on the Report toolbar.
In the Select Group list, select the group that contains the field(s) that you want to sort.
In the Sort by list, select the name of the field that you want sort.
Depending on how you want to sort the data in the field, select the Ascending or Descending radio button.
Optionally, if you want to specify the sort order of other fields within the group, select the name of the next field that you want to sort and then, specify ascending or descending order.
Note
The number of sort by lists changes depending on the number of fields contained within the group. For example, if the group contains two fields, then only two Sort by lists appear.
Click OK.
To allow report readers to sort data
In the Report Builder window, click Report Properties on the Report menu.
The Report Properties dialog box appears.
Select the Allow users to sort the report data when they view it check box.
This option is selected by default.
Click OK.
To sort data within a group while viewing a tabular report
In Report Builder run mode, click the up or down arrow displayed beside the field name.
The up arrow sorts the contents of the report column in ascending order. The down arrow sorts the contents of the report column in descending order.
See Also
Concepts
Grouping and Sorting Data (Report Builder)
Controlling Page Breaks, Headings, and Columns (Report Builder)
Other Resources
Sort and Group Dialog Box (Report Builder)