Report preview different than printer output
hi all,
i have an end-user report which has variables in a group footer. the
variables are updated each time a detail band prints and then reset to 0 on
group break. the output on the screen is correct, but when printing, the
variables come up with different numbers than shown on the screen. the
detail band variables are just globals, and then labels in a group footer
band are updated on 'footerband.beforegenerate'. i have set the report to be
one pass only, hoping this would help...but, it has not.
what am i doing wrong?
also, i notice that moving back and forth through the report will change the
totals as well. ie. the report is a 'time-clock' report which is grouped by
employee name. if an employee has two pages, the totals are correct moving
forward. but, if you go to the next employee and then back to the last page
of the previous employee, you only get the totals for that page. what is the
best way to do this so that you get the totals for both pages of the
employee. lol...hope this makes sense!
thanks,
stacey
i have an end-user report which has variables in a group footer. the
variables are updated each time a detail band prints and then reset to 0 on
group break. the output on the screen is correct, but when printing, the
variables come up with different numbers than shown on the screen. the
detail band variables are just globals, and then labels in a group footer
band are updated on 'footerband.beforegenerate'. i have set the report to be
one pass only, hoping this would help...but, it has not.
what am i doing wrong?
also, i notice that moving back and forth through the report will change the
totals as well. ie. the report is a 'time-clock' report which is grouped by
employee name. if an employee has two pages, the totals are correct moving
forward. but, if you go to the next employee and then back to the last page
of the previous employee, you only get the totals for that page. what is the
best way to do this so that you get the totals for both pages of the
employee. lol...hope this makes sense!
thanks,
stacey
This discussion has been closed.
Comments
as the preview. i switched some of my variables to be set in the OnCalc
instead of the detail band. the only problem that still remains is moving
backwards through the pages. because my variables are being reset on group
breaks, if i happen to go back on page to the 'last' page of a group with
several pages, i only get the totals for that current page instead of the
whole group.
is there a way to avoid recalculating info if they are moving backward
through a report?
thanks,
stacey
Try setting the Report.CachePages property to True and see if that helps the
problem.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Please see the articles in the Calculations thread of the Tech Tips
newsgroups and the Calculations tutorials in the RB Developers Guide.
You need to use TppVariable and the OnCalc event to perform all calcuations.
The TppVariable caches intermediate results between pages, so that when you
page back and forth, the calculations are correct.
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com