Totals in footerband

rbuser

Hi,

I'm trying to create a report with a totalamount in the footerband for
transport to the next page.

If I use groups on the report (I don't use subreports), the totalamount in
the footer always adds the next record (on the next page).

This is both the case with Variables and DBCalc components.

This behaviour doesn't show when 'Keep Group Together' is on.

Is there another way to get page totals together with groups?

Jeroen

digitalmetaphors

This is a known issue, as the report fires the OnCalcs when the report
generatest he bands and then has to back up to support the keep together.
The footer band does not participate in the KeepTogether scheme so its
variable is not restored to the previous state after the KeepTogether action
has occurred. One workaround is to use a variable in the detail band (the
bassi for placing it in the detail band in stead of the footer is because
the engine should restore it to the correct state to support KeepTogether)
which has the value and then display it in the footer when the footer goes
to print. You can have an invisible variable, and it will still calculate
correctly.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

do I need to use the DetailAfterPrint event to set the value for the
variable in the footerband?

Jeroen

digitalmetaphors

Try this demo's approach. It can get tricky and this technique is a
workaround to the limitations of other techniques by using the report output
from the engine after the report engine has done its job.

http://www.digital-metaphors.com/tips/RunningSummaryTotalInFooter.zip


Cheers,

Jim Bennett
Digital Metaphors