Paging through a report

rbuser

I have created a simple detail report in ReportBuilder that adds up a sum of
numbers printed in the Detail band. Every time I page backwards and
forwards, however, the sum reported in the report footer is increased by the
sum of the numbers on the pages reviewed.

Ie. When the report first runs, the sum at the end of the report is
correct. However, if I back track, the sum at the end of the report
increases simply by reviewing the pages.

I am assuming that it has to do with the "Detail Before Print" procedure,
but how can I use this without this problem occurring?

digitalmetaphors

Use a TppVariable and use its OnCalc event handler. The pages are actually
being regenerated and the OnCalc of the variable is coded so that it
restores from cache the value so that it should show the proper records as
you page back and forth in the report. Otherwise, set Report.CachePages to
true to keep the pages from being regenerated as you request them in the
previewer.


Cheers,

Jim Bennett
Digital Metaphors