Sort the detail section of a report

You can sort the lines in the detail section in ascending or descending order. You can also sort on multiple fields.

Example:

For example, you can sort a report with outstanding debtor items on debtor first and then on voucher number or amount.

You can also sort other sections, but in that case the procedure is different.

To sort the detail section of the report:

1. Open the report layout.
2. Go to: Report / Group or click on .

   

3. To sort the detail section, add the appropriate fields to the Sorting detail data box.
4. Click on: Add.
5. Select the Name field you want to sort by.

   

6. Click on: OK.

   Profit shows the field in the Sorting detail data box. Data will be sorted in ascending order.

   

7. Click on: OK.

To sort by two fields:

1. Go to: Report / Group or click on .
2. Add a sort.
3. Use the arrow keys to put the fields in the correct order.

   

4. Click on: OK.