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 7:41PM
    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 7:41PM
    Hi
    Dear gordk .

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


    Thanx again.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.