Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

    NoteNote

    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.

    NoteNote

    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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.