Printing problem.

rbuser

I have a problem with a report where if the user displays the report in the
viewer and moves to the last page then a calculated value in the summary
band is incorrect, however, if they move up one page and back then that
value is correct. If the display the first page of the report and then
click the print button, the printed version is correct, however, if they
then move to the last page that value is incorrect, but again if the move up
one page and back again the value is correct. It appears that the value
being added multiple times is the last one displayed in that calculated
column on the report. Any ideas on how to prevent the display from being
incorrect?

David Looney

nicocizik

Hi David,

As a test try disconnecting all your event handlers and see if that helps.
You can also try setting the Report.CachePages to True. If you still cannot
locate the problem, please send a small example of this behavior in .zip
format to support@digital-metaphors.com.

--

rbuser

Well all the calculations are done in a ppvariable.oncalc event so if I
disconnect the events nothing will be calculated.

David

nicocizik

Hi David,

Please send an example of this in .zip format to
support@digital-metaphors.com and I'll find a solution for you.

--

rbuser

I don't think I can reproduce this behavior but I will try. One thing I
didn't put in my original message was that the value I'm totaling on is a
value from a subreport. I've got a subreport on my detail band that only
has a summary band in it and it is summing on a given field. This value is
the added to the grand total field on the main detail line which is the
value that is coming up incorrect at times. Is there anyway to be sure that
a field value with not be added more than once when there is a page break?
It appears that this may be one of the problems I am seeing. I can find
records on the report with the value that the grand total is off by and it
is either the last record on the report or the first record after a page
break.

David