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

Group Header & ppVariable.oncalc event

edited July 2003 in General
Hi,

I've got a report(customer statement) with following attributes
-Group Header which breaks on customer number.
-ppVariable field in Group Header which contains Balance Forward Amt,
calculated in OnCalc event.
The algorithm code in the OnCalc event relies on
ppReport.Pageno to correctly calculate the Bal Fwd amt
-report driven from customer account transactions

The Problem
Everything works fine except where all the customer account transactions fit
neatly onto the first page
and then the second page contains the Group Header and the Group Footer
only, no transactions.
There does not seem to be an OnCalc event fired for the second page and so
the Bal Fwd Amt value remains set
at its initail value(ie at the beginning of the customer statement).
If I add another transaction such that there is one transaction on the
second page everything works fine, the oncalc
event is fired.

Cheers

Tony Peppercorn

Comments

  • edited July 2003
    Hi Tony,

    It sounds like there is not quite enough space for the Group footer so it is
    going to the next page. A way around this would be in the
    DetailBand.AfterPrint, check to see if you have enough space at the bottom
    of the report for the footer and if you do not, set the group footer's
    visible property to True.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2003
    thanks Nico, I'll give it a go

    Tony

    --
  • edited July 2003
    Nico,

    What is the effect of setting the Visible property to true. Does this cause
    the required events to fire?

    Cheers

    Tony

    --
  • edited July 2003
    I'm sorry, you will want to set the group footer's visibility to False if
    there is not enough room to fit it at the bottom of the page.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.