Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Help With Sum Calc on variable

edited June 2006 in End User
Am very new to this, hopefully this is the correct place to post this.

The basic problem is i am trying to get a sum total in the footer based on a
variable calc in the detail field.

In the detail field a variable has been setup (variable1) with the following
code:
Value := Parts['Sellprice'] - (Parts['Sellprice']/100 * Parts['Discount'])

The report when run would include many jobs, the individual totals this
field generates per job are correct.
In the footer i need to total up this variable for all the jobs , same as a
Sum Calc would, only thing is i cant find how to write it to do this for a
variable.

Many thanks
Stuart

Comments

  • edited June 2006
    Hi Stuart,

    Try placing another TppVariable inside the footer and update its value in
    the OnCalc of the variable in your detail band. For instance...

    Value := Parts['Sellprice'] - (Parts['Sellprice']/100 * Parts['Discount'])
    ppVariable2.Value := ppVariable2.Value + Value;

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.