Hi,

I have an invoice where we need to "roll up" the all the lines into one line.

From something like this:

Item          Description               Qty               Price          Total
-----------------------------------------------------------------------------------------------------------
12345          Item A                    1               100               100
23345          Item X                    2               150               300
76345          Item ZZ                    1               750               750
87345          Item KA                    5               50               250
-----------------------------------------------------------------------------------------------------------

To this:

Item          Description               Qty               Price          Total
-----------------------------------------------------------------------------------------------------------
12345          Item A                    9               1050          1400
-----------------------------------------------------------------------------------------------------------

Basically, I would like to "Print" the first line, but keep summing up the subsequent rows to arrive at a final total.

I have looked at Running Totals, but this only works on lines that are visible (printed)

Regards
Brendan

Hi DBlank,

Thanks for your suggestions. This report is based on a SAP B1 invoice, and there are many groups and sub-reports in the report.

I will let you know how I get on

regards
Brendan