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









Comments

  • gordkgordk St.Catherines On. Canada.
    edited 1:04PM
    start of report code page declare var of type required
    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">;
  • edited 1:04PM
    Hi
    Dear gordk .

    Thanx U , I do this , but i want to do this whitout CODE!!


    Thanx again.

Leave a Comment