You need the Advanced Reporting permission to apply sorting to an Advanced Report if you want the data in one or more fields displayed in alphabetical or numerical order to enhance the report's usability.
Click Reports in the Navigation Toolbar, and click the Reports link in the menu.
In theReport Browse screen, locate the Advanced Report whose data you want to sort, and double-click the report record.
Tip:
An advanced report is displayed under a Report Group: Advanced Report header. Expand/collapse a report group using the ^ and v icons.
In the report layout screen, click Configure Sorting in the toolbar to display a Configure Sorting window.
In the Configure Sorting window:
Click Main Report in the Report Section to display a list of the fields in the main report that can be sorted.
Click a field in the list in the Add Fields section to add it to the Order Fields section.
Click Delete to remove a field from the sort order.
(Optional) Use the arrows to change the sort priority for the fields
selected.
(Optional) Click a sub-report in the Report Section to display a list of
sub-report fields that can be sorted, and repeat the steps above.