Help With Sum Calc on variable
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com