Sorting data

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:

You can sort the data in your report in either ascending or descending order.

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.