Sorting report data

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

Sorting records: Changing the order of records in the whole table, crosstab or chart, 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, crosstab or chart, 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, crosstab or chart; 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: If you use the shortcut menu to sort the report data by a field and then sort by another field, the later sort condition will replace the former one.