Funny problem with printouts

[varunmathur]

My reports contain totals in the page footer which are running sums of the Paid fields of the page. The totals appear correct on screen but when I print the report the total becomes 00.00,
Please help.
varun

 

[pdx_man]

If there is VBA behind this report aiding in the calculation of the control in the group/page footer, I have had this problem (and fixed it).

Notice in the PageFooter_Format line that there is a parameter called FormatCount. Play with that in debug mode and see what is actually happening with the calls to this procedure.

 

[varunmathur]

Hi pdx_man
My reports page footer is really loaded with VBA.(1) calculates the running sum of a field in the detail section of the page.
(2) Converts this number into words.
(3) adds 1 to the number
(4) Converts this new number into words.
I think I am asking for trouble, but I have to have these totals and figures in the page footer.I will try to play around with the pagefooter_format I am not sure how to go about it.
Thanks
Varun