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

Creating sum of calc fields

edited December 2002 in End User
Hi,

If I have a variable used for a calculation in a detail line, what is the
preferred way to total the sum of detail lines at group level?

Thanks

Alex

Comments

  • edited December 2002
    If you have a TppVariable calculation, then use another TppVariable to
    calculate the total of that variable. What you can do is use the OnCalc
    where you calculate the value in the Detail band and update the value in the
    variable in the group footer as well. This way you don't have to code
    another OnCalc for the group footer variable. It will have a group based
    total, because it gets reset on every group break as defined in the timing
    dialog of that group footer variable.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.