Reports: How do I add sorting to reports on Reports and Maintenance?
Description

You are able to apply sorting to report on the Reports and Maintenance menu, which will allow you to customise the sorting of data on the report.

This article will provide you with steps to apply sorting to the report.

Cause
Resolution

When printing reports you can select to sort them by selected descriptions on the payroll:

Step 1

From the Main Menu:

  • Select Reports
  • Select Reports and Maintenance

Step 2

Locate the report to sort:

  • Click once on the report to select
  • Click on the Change an existing report button 

Step 3

Edit the report sorting fields

  • Select the Sort Control Field magnifying glass to view the options to sort by.
  • Subject to the report to sort, you will have the following options:
    • A list of Valid Sort Codes for Breaks will appear. This list does not allow selections, but shows you the codes you can enter under 'Field' to sort the report by, which you will need to  enter manually. For example: 

            

    • Some reports will allow you to select any code as per the Data Dictionary (Report Writer codes)
    • Some hardcoded reports will not allow any selection, at which point you will get an error message

 

  • You can then select if you want a total per sort, and/or if you want each sort to print on its own page
    • Total - Will total up financial values per sort break
    • Page - Each sort break will start on a new page

 

Steps to duplicate
Related Solutions