Question about Aggregates

rbuser

I've noticed in one report that has 4 Grouping levels with two dbSUM's on
each group that it takes quite a while to render the report. It hangs on
one particular page for about 15-20 second. That particular page show data
summarized from about 800 records (grouped by date). Should I try to Sum
these values in the underlying query rather than leave it up to the report
engine?

Thanks

Lee


--


Didn't we go to different schools together?

digitalmetaphors

It may be faster to have the query provide the summary calculations. The
DBCalc should fire its OnCalc every time the report engine traverses a
record in the datapipeline. Are you firing a summary query for the summary
band? There shouldn't be a performance hit on calculating the summary with a
DBCalc, since all of the pages are generated before the page with for
summary data prints (meaning that the DBCalcs should have the sum already
calculated immediately after the 800th detail record prints).


Cheers,

Jim Bennett
Digital Metaphors

rbuser

The only thing I'm putting in the band (footer of group) is DBCalc field.


Lee

digitalmetaphors

One thing you could do is use the Event Tracker demo appraoch to see how
often the DBCalc.OnCalc is firing. What you should see is that the
DBCalc.OnCalc will fire every time a record is traversed by the report
engine.

Upgrade to RB 6.03. If that doesn't help, could you send an example to
support@digital-metaphors.com and we'll look into this issue in the
debugger. I created a test project and the evetns are firing at the correct
time, so there must be something I'm missing.


Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

Sorry, the forgot to say that the event tracker demo is located in your
installed RBuilder/Demos/Reports project. Look at #141-150


Cheers,

Jim Bennett
Digital Metaphors