Summary
This guide explains how to use sorts to arrange data in order on a report or layout using Sage Report Designer.
Description
Using Report Designer, you can add a sort to your reports and layouts. This is useful when you want to see items arranged in a certain way, for example alphabetically.
Resolution
Add a sort

- Select the document you want to amend, then click Edit.
- On the menu bar click Report, click Report Properties.
- Enter a new report name and description, then click OK.
- Click Report, then click Sorts.
- Click Add.
- Choose to sort the data according to the value of a variable, or to sort based on an expression, then choose to sort in ascending or descending order, and click OK.
- Click File, click Save As.
- Enter a new file name then click Save.
- Click File, then click Exit.
Edit a sort
- Select the document you want to amend, then click Edit.
- Click Report, click Report Properties.
- Enter a new report name and description, then click OK.
- Click Report, then click Sorts.
- Click the sort, then click Configure.
- Amend the sort as required then click OK.
- Click File, click Save As.
- Enter a new file name then click Save.
- Click File, then click Exit.
Further support
For further help with Sage Report Designer, please log a case online to our Report Design support team.
Upgrading your licence Need a little more room? To add extra companies, users, employees or more to your software licence, leave your details and we'll be in touch.