How shows "invoiced quantity" divided in months in a report

DarkHorse

Hi, I've a fool problem with a report. The report has several dataitems and one of the last is "Item ledger entry". In onpredataitem I've put:

CurrReport.CREATETOTALS ("invoiced Quantity");

"Item Ledger Entry". SetRange ("Posting Date", CALCDATE ('<-6M>', WORKDATE) WORKDATE);

And then, in sections, I have a footer with "Quantity invoiced" field. What it does is shows the amounts charged for the last 6 months, and it do it correctly. But now I want to add the last three months and the last month in the same section, but I can't.
How can I do this, please?.
Thank you very much.

Savatage

Have you thought about using an array?

There is a post about how to do this - and i've done it for Customer Sales by Month & Vendor Purchases by month.

It could easily be changed to breakdown "Sales (Qty.)" by month too.
read more here:
viewtopic.php?f=5&t=10082
It Looks Like This:
https://sites.google.com/site/savatage9 ... edirects=0

DarkHorse

Thanks for help; but the report is already done. The report has many others calculations and this is only a small part that appears at the bottom on each Item in the manner I've explained.
Thanks for help.