If you are creating a report with grouped data and have selected one or more break fields, you see them at the top of the Sort order list with a lock icon. You can't remove them or change their position because the records must be sorted by those fields first for the report categories to display properly.
|
|
|
In Report fields, double-click the fields you want, in the order you want them used in the sort hierarchy. (Or, select a field, then click Move.)
|
|
In Sort order, double-click the field you want to remove. (Or, select a field, then click Clear.)
|
|
In Sort order, drag the double arrow next to the field name to a new position.
|
|
•
|
Ascending order to sort in alphabetical order for text, lowest to highest for numbers, and earliest to latest for dates and times.
|
•
|
Descending order to sort in reverse alphabetical order for text, highest to lowest for numbers, and latest to earliest for dates and times.
|
•
|
Custom order based on value list and choose (or define) a value list to sort in the order that matches a field's value list. For example, sort in order by month.
|
|
|
In Sort order, select the non-summary field that you want to reorder based on the values in a summary field. Click Reorder based on summary field, and click Specify. In the Specify Field dialog box, select a summary field and click OK.
|