Is there a way to sum a data field other than dropping a ppCalc object on the form? I want to do some summary calculations in a group footer band with the sum of a data field, but do not want to print that data field.
If you simply place a dbCalc object inside the GroupFooter band and set it's field name, it will give you the sum of that field without the need to print all the field values. You can also use TppVariables to do this, by having an invisible TppVariable in the detail band and in its OnCalc event, updating the value of another TppVariable in the GroupFooter. Either way should work correctly.
Comments
If you simply place a dbCalc object inside the GroupFooter band and set it's
field name, it will give you the sum of that field without the need to print
all the field values. You can also use TppVariables to do this, by having
an invisible TppVariable in the detail band and in its OnCalc event,
updating the value of another TppVariable in the GroupFooter. Either way
should work correctly.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com