Sum function (in the line)?
Hi,,,,,
i have a database table Like :
Name Price
XXXXXX 1000
XXXXXX 2000
XXXXXX 3000
XXXXXX 1000
XXXXXX 500
How in can doing this report :
Name Price Current Total
XXXXXX 1000 1000
XXXXXX 2000 3000
XXXXXX 3000 6000
XXXXXX 1000 7000
XXXXXX 500 7500
I used (with CurrentTotal) :
[SUM(<Table1."Price">)]
[<SUM(<Table1."Price">,Band4)>]
[SUM(<Table1."Price">Band4,3)]
it's not work !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
please help me
Thanx
i have a database table Like :
Name Price
XXXXXX 1000
XXXXXX 2000
XXXXXX 3000
XXXXXX 1000
XXXXXX 500
How in can doing this report :
Name Price Current Total
XXXXXX 1000 1000
XXXXXX 2000 3000
XXXXXX 3000 6000
XXXXXX 1000 7000
XXXXXX 500 7500
I used (with CurrentTotal) :
[SUM(<Table1."Price">)]
[<SUM(<Table1."Price">,Band4)>]
[SUM(<Table1."Price">Band4,3)]
it's not work !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
please help me
Thanx
Comments
ie
var
curtot : extended;
add a memo beside the one containing price with [curtot]
in obp event of band
write code
curtot:= curtot +<Table1."Price">;
Dear gordk .
Thanx U , I do this , but i want to do this whitout CODE!!
Thanx again.