Advanced report writer (ARW)
Description

If you have specific reporting requirements of your own. To meet such requirements, you can use the Advanced Report Writer (ARW) software that came free with Sage Payroll to design your own reports.

NOTE: Need a report created just for you? We can design this for you. For more information, Contact our technical support team to discuss your requirements in more detail. 

Cause
Resolution

Log in to ARW

  1. From the Windows desktop, open the relevant tax year version of ARW. For example, ARW 2021.
  2. When prompted to log in, enter the same log in details as you do to open Sage Payroll then click Ok.

    The sign on screen for the Advanced report writer.



    NOTE: If either of the following messages appear, you must Install an ODBC driver: 

    • 'Data Source Error Filling Lattice'
    • 'Cannot Read User File - Please ensure that ODBC is installed' 
  3. Once you've successfully logged into ARW, the main window appears:

    The advanced report writer screen.


Create a new report in ARW

  1. From the main ARW window appears, click Create Report.
  2. Select the relevant Sage Payroll master data file that you can pull payroll information from.
  3. Double-click New.
  4. Select the fields you want to display on the report, then click OK.
  5. If you want to reposition a field, select the relevant field then click either Up or Down, until the field is in the correct position.
  6. To remove a field completely from the report, select the relevant field then click Remove.
  7. To add additional fields to the report, double-click New, then select the relevant fields and click OK.
  8. To edit a field's attributes, select the relevant field then click Format. Make the necessary adjustments, then click OK to save the changes you've made.
  9. Repeat step 8 for all fields that you want to change attribute details for.

    TIP: If you want to, you can Sort the information on this report into a specific order. Add filters to restrict particular data field information from appearing on your report or Use the values of other fields to perform calculations.

  10. Click Printer Setup then click Printer.
  11. Under Orientation, select Landscape.
  12. Check the rest of your printer settings are correct, then click OK.
  13. Enter the report name in the Report Name field - this name will appear in the Menu window in ARW.
  14. Click Save, browse to the location you want to save the ARW report to.
  15. In the File name box, enter a title for the report (up to eight characters in length), then click Save.
  16. To proceed, complete one of the following options:
    • To view the output of the report, click Preview.
    • To print the report, click Print, check the printer settings and edit if required. Then click OK.
    • To run the report in to Microsoft Excel, click Excel.
    • To save the report as a CSV or TXT file, click File Output. Browse to the location you want to save the file, then select the Save as type option and click Save.
  17. To close out of your ARW software, click Exit.

Open or edit an existing ARW report

  1. Log in to ARW.
  2. Under Menu, select the relevant report then click Edit.

    The screen to edit the Advanced Report Writer.

  3. To add fields to the report, scroll to the bottom of the list, and double-click New.
  4. Select the fields you want to display on the report, then click OK.
  5. Make any necessary changes to the report, then click Save and then click Save again.
  6. When prompted File Exists, Do you wish to Override?, click Yes and then click Yes again.
  7. To proceed, complete one of the following options:
    • To view the output of the report, click Preview
    • To print the report, click Print, check the printer settings and edit if required. Then click OK
    • To run the report in to Microsoft Excel, click Excel
    • To save the report as a CSV or TXT file, click File Output. Browse to the location you want to save the file, then select the Save as type option and click Save

Other report options in ARW

[BCB:177:Mia - B:ECB]

 

Steps to duplicate
Related Solutions