Variable for dynamic sum
Posted: Mon Oct 11, 2010 3:21 pm
Hi everyone,
I have a table like this
I would like to display one row for each sale with a cumulative sum of sales by product
How can I do that?
I use one variable, in "After Print" event on GroupHeaderBand
variable=0
And in "After Print" event on DataBand component
variable=variable + SALES
but the result (wrong) i get is:
Thanks!
I have a table like this
Code: Select all
Product INVOICE SALES
A 1 3
A 2 2
A 3 -1
A 4 4
B 2 2
B 8 1
Code: Select all
PRODUCT A
INVOICE SALES SUM
1 3 3
2 2 5
3 -1 4
4 4 8
PRODUCT B
INVOICE SALES SUM
2 2 2
8 1 3
I use one variable, in "After Print" event on GroupHeaderBand
variable=0
And in "After Print" event on DataBand component
variable=variable + SALES
but the result (wrong) i get is:
Code: Select all
PRODUCT A
INVOICE SALES SUM
1 3 3
2 2 2
3 -1 -1
4 4 4
PRODUCT B
INVOICE SALES SUM
2 2 2
8 1 1
Thanks!