How to Imporve Report Perfomance
First of all, there is no good reason to run a query before opening a report.
The report and the sub-reports will call the queries independently. So
executing the queries just wastes time.
Next, I would not use sub FORMS on a report. I would use sub REPORTS on a
report.
Check that the fields involved in limiting the records or sorting the records
are indexed. Also make sure the indexes for the fields used in the links
between the main report and the sub-reports are indexed
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
mrPela wrote:
I developed a report and it takes literally 30 minutes to open up. How do I
improve performance. The data set is a local table that is not on the back
end of the database. However there are about 4 sub forms on the report. These
subforms are all queries. I requery the subform queries prior to opening up
the report. What are some things that I can do to make this report open a lot
quicker?
|