Preview performance

rbuser

Hi,

I have a simple report with one detail band per record in the dataset.

When RBuilder is asked for a preview of the first page of the report, with
PassSetting = psOnePass, it appears to read all the records in the dataset
before displaying the first page. At least this is what monitoring the app
with CodeWatch seems to say.

For this particular report, the first page only requires data from the first
record. I realize this is not the case for reports in general. But for
this report, the preview is rather inefficient when the dataset is large.

I don't see any settings (other than PassSetting) that would influence
RBuilder's behavior here. Am I missing something?

Thanks.

Mike Carroll
Sigma Data Systems, Inc.

digitalmetaphors

The designed behavior of the report engine is that it only read the records
needed for the generating page. One possibility is that something is
flipping the report to TwoPass even though you set it to OnePass. This could
happend due to a number of reason including loading a report from a Template
with the PassSetting defaulting to TwoPass or enabling a variable's
LookAhead property. To be sure that the report is really OnePass place a
breakpoint in the report's BeforePrint event and query it's PassSetting
property at that point.
--
Cheers,

Alexander Kramnik
Digital Metaphors