Page totals
In a report I have some currency columns and some group footers in which I sum the values for that group with DBCalc
controls. I also have grand totals in a summary band.
However, I also need page totals independent of the group bands. I tried DBCalc controls in the footer (which prints at the
bottom of each page), but that gave the same values on each page as the grand total on the last page. How do I do this so
each page shows the sum of the detail only on that page?
Thanks,
Jon Jacobs
controls. I also have grand totals in a summary band.
However, I also need page totals independent of the group bands. I tried DBCalc controls in the footer (which prints at the
bottom of each page), but that gave the same values on each page as the grand total on the last page. How do I do this so
each page shows the sum of the detail only on that page?
Thanks,
Jon Jacobs
This discussion has been closed.
Comments
The DBCalc component does not allow you to reset its value based on a page
break, however the TppVariable does. Try placing an invisible TppVariable
inside your detail band and in its OnCalc event update the total value of
another variable located in your page footer band. Then set the second
variable's timing to reset on Page Start.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com