When you're designing an Advanced Report Writer (ARW) report, you can sort the information into a specific order. For example, if you have a report that lists your employees and their date of births, to show the oldest employees first, you can sort the report by date of birth.

1. Click Sort.
   
   
   
2. Double-click New.
3. Select the fields you want to use for sorting, then click OK.
4. Beside the relevant field, in the second column, double-click the option to specify Ascending or Descending order.
   
   
5. Beside the relevant field, in the third column, double-click the option to specify one of the following:
   • No Sort Break - On the field selected, the report will not break per sort.
   • Sort Break - The report will break on the field selected and gives a total.
   • Sort Break with new page - The report will break on the selected field giving a total and a new page after each sort definition.
6. Click OK.