Sorting report data

You can make the data displayed in either descending or ascending alphabetical order in a report.

Sorting data in charts

Data labels on the category or series axes of a chart can be sorted alphabetically. To do this, select the chart, right-click the icon of the chart or right-click on the chart platform or paper, then on the shortcut menu, select Ascend or Descend from the Sort Category or Sort Series submenu.

To remove the sort condition, click No Sort on the Sort Category or Sort Series submenu.

Sorting data in tables/crosstabs

You can sort the records or groups at a certain group level in a table or crosstab.

Sorting records: Changing the order of records in the whole table or crosstab, or in each group if there are.
Sorting groups at a group level: Changing the order of groups at the specified group level, that is, the groups will be sorted by value of the group field.

To sort data on a certain field using shortcut menu:

Point to any value of a detail field or group field by which to sort the data in a table or crosstab and then right-click.
Choose the command Sort > Ascend or Sort > Descend from the shortcut menu.
If what you right-click in Step 1 is a detail field value, the sorting will affect the order of detail records in the table or crosstab; if it is a group field value, the order of groups in the group level represented by the group field will be rearranged.

To remove the sort condition on a field, click Sort > No Sort from the shortcut menu.

Note: When you use the shortcut menu to sort the report data by a field and then by another field,

For a table, the later sort condition is the major order, and the former condition the minor order, that is to say, the records in the table will be sorted by the later sort condition first, then by the former sort condition.
For a crosstab, the later sort condition will replace the former one.