Speeding up a report

  • Thread starter Kath via AccessMonster.com
  • Start date
K

Kath via AccessMonster.com

I have a master report with 3 subreports which groups on a Site and is
filtered by a Prompt of a Bill Date. This report is taking forever - is
there anything I can do to speed up a report that is using a total of 4
queries (which some of those reference other queries as I am totaling based
on aggregated services and payments, etc. which are from multiple tables?)
 
J

Jeff Boyce

You don't mention how long it takes the individual/separate queries to run.
Is this slowdown true of the underlying queries, or only when you combine
them into the report?

Are all the fields you use to join, select, group by and sort already
indexed in the underlying tables?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

david epsom dot com dot au

don't use "pages" to get "page 1/30". That slows down
reports, and particularly slows down the first page of
reports.
 
K

Kath via AccessMonster.com

The queries run ok, the fields used to link are all indexed. I tried removing
the "pages" and this did improve the report performance significantly.

Thanks!!
Kathie
 
Top