Skip to content
logo Knowledgebase

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

Created on  | Last modified on 

Summary

In Report Designer you can use the Count and Evaluate Section properties to show how many records appear on your report. This article explains how to add a count to your report.

Description

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.

Resolution

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.

Image