This article has been prepared and issued to you as a goodwill gesture only and Sage accepts no liability or responsibility for its use. For further support please refer to your Business Partner.

Add, edit or remove a sort on the document

1. Report Designer > Open the Report menu > choose Sorts > amend the sorts as follows:
   
   Report Designer v1.3 and below - Open the Data menu > choose Sorts > amend the sorts as follows:
   
   

   Tip: You can check your Report Designer version in Help > About > Application > File Version.

   To add a new sort	Add > to sort the data according to the value of a variable, select the relevant option then choose the required table and variable from the drop-down lists, for example, SLCustomerAccounts.CustomerAccountName > select to sort either in descending or ascending order > click OK. Note: To sort the data according to the value of an expression select the relevant option then either enter the expression manually into the Expression text box, or to use the Expression Editor to create the required expression, click Edit Expression. For further information about creating expressions please refer to article .
   To edit an existing sort	Select the sort > Configure > amend as required > OK.
   To delete a sort	Select the sort > Remove.

2. If you've added more than one sort, to change the order of the sorts use the spin buttons at the top right of the Sorts window.
   
   Note: If your report is grouped, data is sorted by the group before any additional sorts are applied. Group sorts do not appear in the Sorts window and are instead held within the properties of the group. For further information about groups, please refer to the information here.
3. Click OK.

You have successfully added a sort to your document. You should make any further changes required and then save the document. For further information, please refer to the following section.

Save the changes to your document

1. Report menu > Report Properties > Report Name > enter a new name for the document > Report Description > enter a new description for the document > OK.
   
   Report Designer v1.3 and below - Report Explorer pane > select the document name > Properties pane > Name > enter a new name for the document > Enter.
   
   

   Tip: You can check your Report Designer version in Help > About > Application > File Version.

2. File > Save As > File name > enter a new file name for the document > browse to the required location for your document > Save.
3. File > Exit.

You have now saved the changes in a new document.