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

Totals in footerband

edited January 2003 in RAP
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

Comments

  • edited January 2003
    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


  • edited March 2003
    Jim,

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

    Jeroen


  • edited March 2003
    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


This discussion has been closed.