Page 1 of 1

Problem with "Partial Sum" in Report

Posted: Thu Apr 23, 2009 7:53 am
by aminformatica
Hi all,

I have this problem: I have to do a report that list the table records and do a partial sum item of a "TOTAL" field.
For example, the table contains this records:

RECORD 1
MONTH = "JANUARY"
TOTAL = 100 .

RECORD 2
MONTH = "FEBRUARY"
TOTAL = 150 .

RECORD 3
MONTH = "MARCH"
TOTAL = 200 .

Now, the reports should show a partial sum of the colum "TOTAL", in this way:

MONTH | TOTAL | PARTIAM SUM
----------------------------------------------
JANUARY 100 100
FEBRUARY 150 250
MARCH 200 450

Can you help me please?
Thanks!
Best regards,
Maurizio


Problem with "Partial Sum" in Report

Posted: Thu Apr 23, 2009 8:26 am
by Brendan
Hi,

You can use the SumRunning function to calculate a running total for your databand

Code: Select all

{SumRunning(DataBandName, MyDataSource.AmountColumn)}
Place the code above into a Text Component on your page