This document demonstrates how to sort data within a report's detail area and within groups. Note that as with data grouping, sorting can be performed only if a report is bound to a data source. Grouping Data.
To sort records in a data-aware report, do the following.
Select the Detail Band and expand the Actions category. Then, in the Sort Fields section, click the Add button to add a new sorting.
Now, choose a data member across which the report is to be sorted. Note that sorting across calculated fields is supported as well.
To manage the sorting order, use the arrow button for the Sort By drop-down list. The and icons indicate the ascending and descending sorting order, respectively. To disable sorting, click this button until it is marked with the icon.
If multiple sorting criteria are specified, you can define the priority for each one, using the Move Up and Move Down buttons.
Sorting is now applied. Switch your report to the Preview mode and view the result.