When you first add an attribute to your report, the data appears in the order in which it was originally entered into the database. It is much easier to review or find information when you can see it sorted in a logical format. For example, you may want to have a Customer list sorted alphabetically by name or by country.
When you sort data, you need to specify two things:
The attribute that you want the sort to be based on.
The sort direction – either ascending or descending.
You can sort the data in your report in either ascending or descending order.
Ascending – smallest to largest (1 to 9, A to Z, False to True). The Report Designer sorts the records in ascending order based on the values in the sort attribute you select.
Descending – largest to smallest (9 to 1, Z to A, True to False). The Report Designer sorts the records in descending order based on the values in the sort attribute you select.
If required, you can select more than one column with which to sort your data. You can sort your report by any column, apart from columns that contain free text such as Details.
If you want to group the report, you must specify at least one sort order.