Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

How to: Sort Data (Report Builder 1.0)

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

  1. In the Report Builder window, click Sort and Group on the Report menu.


    Alternatively, click the Sort and Group button on the Report toolbar.

  2. In the Select Group list, select the group that contains the field(s) that you want to sort.

  3. In the Sort by list, select the name of the field that you want sort.

  4. Depending on how you want to sort the data in the field, select the Ascending or Descending radio button.

  5. 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.


    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.

  6. Click OK. 

To allow report readers to sort data

  1. In the Report Builder window, click Report Properties on the Report menu.

    The Report Properties dialog box appears.

  2. Select the Allow users to sort the report data when they view it check box.

    This option is selected by default.

  3. 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.

Community Additions

© 2015 Microsoft