Group Header & ppVariable.oncalc event
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
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
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Tony
--
What is the effect of setting the Visible property to true. Does this cause
the required events to fire?
Cheers
Tony
--
there is not enough room to fit it at the bottom of the page.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com