Report Records Count.

Business Central/NAV Developers Forum
1

Hi all

I want to count the Number of records (Printed Lines) on a certain Body section of my report and display the total value on the report.

How do i manage this?

Thanx

2

Try this:

Define a global variable eg.NoOfRecords, then OnPreReport(), include

NoOfRecords := COUNT()

Display as footer

3

COUNT in OnPreReport will count all records within initial filter before the output.

Although this [probably] will not work in the upcomming NAV “>5.0”, the current solution is an INTEGER-variable and an adding to the variable in the OnPreSection (inCounter += 1;).