Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Paging through a report

edited May 2003 in Subreports
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?

Comments

  • edited May 2003
    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


This discussion has been closed.