Sage 200 Report Designer - How to show how many records are on a report

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.

To add a record count to your report

To show how many records are on your report, you must add a non-transactional variable into the Report Footer section of the report. You must ensure the variable's Function property is set to Count and set Evaluate Section to the relevant report section.

1. Variables pane > expand the required table, for example, SLCustomerAccounts > variables list > select the variable that you require. Note: Select a variable which appears on the report for each item you want to count. For example, if you want to count the number of customer records, select CustomerAccountNumber.
2. Click and drag the variable into the Report Footer section of the report > if an Active Complete window appears, click Cancel.
3. Properties pane > Function > choose Count > Evaluate Section > choose the footer section which corresponds to the records you want to count. For example, if you want to count the the number of customer records, select CustomerAccountNumber Footer.

You have now amended your report to show the number of records included on the report.

If you are viewing this article from the Sage website, a list of Sage 200 Report Designer articles are available now.

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.