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.

Add a sort

1. Select the document you want to amend, then click Edit.
   
   
   
   
2. On the menu bar click Report, click Report Properties.
3. Enter a new report name and description, then click OK.
4. Click Report, then click Sorts.
   
   
   
   
5. Click Add.
6. 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.
   
   
   
   
7. Click File, click Save As.
8. Enter a new file name then click Save.
9. Click File, then click Exit.

Edit a sort

1. Select the document you want to amend, then click Edit.
2. Click Report, click Report Properties.
3. Enter a new report name and description, then click OK.
4. Click Report, then click Sorts.
5. Click the sort, then click Configure.
6. Amend the sort as required then click OK.
7. Click File, click Save As.
8. Enter a new file name then click Save.
9. 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.

[BCB:180:Andy Footer:ECB] [BCB:149:Move feedback:ECB]

[BCB:19:UK - Sales message :ECB]