Count number of rows with the same Date.

mysamza

I am developing a Sales Summary Report from scratch.
This report brings data from table "Sales Invoice Line."

The idea is, to Group the Amount values by Posting Date.
I am doing this Grouping in RDL.

So let us say, the "Sales Invoice Line" has 3 records;
Posting Date - Amount
01/01/2021 500
01/01/2021 200
02/01/2021 100

My report shows;
Posting Date - Amount
01/01/2021 700
02/01/2021 100

However, I am required to also show a 3rd column in the report;
Posting Date - Amount - Total Invoices
01/01/2021 700 2
02/01/2021 100 1

Here is the code I have written for this report;
dataset
{
dataitem("Sales Invoice Line"; "Sales Invoice Line")
{
RequestFilterFields = "Posting Date";
column(Posting_Date; "Posting Date")
{

}
column(Amount; Amount)
{

}
trigger OnAfterGetRecord()
var
myInt: Integer;
begin

end;

trigger OnPostDataItem()
var
myInt: Integer;
begin

end;

}
}
I need help in knowing the best method to get Total Invoices values in my Dataitem.

jordi79

Getting total invoice count in NAV dataitem will not be easy. THe easier option would be to use the COUNT function in the RDL report. SUM and COUNTs are way easier to do in the report, compared to doing it in the dataitem.

jordi79

Getting total invoice count in NAV dataitem will not be easy. THe easier option would be to use the COUNT function in the RDL report. SUM and COUNTs are way easier to do in the report, compared to doing it in the dataitem.