The time it takes to populate a report

[dvlander]

I have a report that takes 20-25 seconds to fully populate all data. The
report has quite a few DSums that likely contribute to the delay. In terms
of system resources and report population time, would I improve response by
creating a Totals Query and then having the control(s) have a DLookup to the
Totals Query instead?

Is there any other preferable option for pulling sum data from a query that
is NOT the record source for the report?

Thanks a bunch,

Dale

 

[Kardan via AccessMonster.com]

Hi Dale

Your suggestion of replacing the DSum with DLookup will not work as you will
just be replacing one domain function with another, it may even be slower if
you have a query to be updated first.

How about using Grouping with headers or footers in the report with Text
Boxes with a Source of '=Sum([MyValueField])'?

Not knowing your data I cannot be sure if this will work. You could also try
indexing your source data table to optimise it for reporting. In case you do
not know, indexing can be likened to filing your data logically in a filing
cabinet rather than having it in one huge pile that just has another record
thrown on top when it is created. Doing this will make the data much quicker
to find.

Regards

Richard