displaying a report

  • Thread starter Thread starter Elaine
  • Start date Start date
E

Elaine

I have a report that is at lease 825 pages long. It contains a subform. It
uses 3 tables that are linked to text files. When I run the report it takes
at lease an hour for it to display. I'm going to be dividing it into
different segments, but even running a smaller report is taking a long time.
Any idea how to speed it up?
 
I have a report that is 2800 pages and runs off at least 6 or 7 queries and
has 3 or 4 subforms and it opens in less than 5 minutes, so you have a
problem somewhere. Are the 3 tables joined in a query? Do you have
relationships between the tables set? (tools/relationships) Do you have
corruption? Try compact and repair (back up your database first.) Do you have
bad code? (try compiling) Also, go to Allen Browne's site, I think he has
some good tips on slow report problems, www.allenbrowne.com
 
A couple of things to consider.
If you have any calculations in your queries, move them to the report.
I would suggest you create static tables and import your text files into the
tables before running the report. You should also set up relationships and
indexes on the tables to improve performance.

If you have any VBA code executing in your recurring report events, see if
you can eliminate it.
 
Back
Top