[AccessD] VERY SLOW report

I believe you have answered your own question.  So many subreports and
calculations.  If your main report and/or the subreports are based on
queries, this might be the case where you could look at creating temp
tables through Make Table queries.  You could also add some of the
calculations in the Make Table queries so that they are stored in the
temp tables.  Your main/sub reports could then be based on these temp
tables.
 
And for those who are grimacing when I say temp tables and storing
calculated values <gr>, sometimes they are a necessary evil to speed up
the program.  In my way of thinking, taking around an hour or to
generate a report is way too long.
 
 

John V. Ruff - The Eternal Optimist :-) 
Always Looking For Contract Opportunities 

Home: 253.588.2139 
Cell: 253.307.2947 
9306 Farwest Dr SW 
Lakewood, WA 98498 

"Commit to the Lord whatever you do, 
                and your plans will succeed." Proverbs 16:3 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan
Sent: Thursday, May 29, 2003 12:17 PM
To: Access List
Subject: [AccessD] VERY SLOW report 


I have an Access 97 report that runs VERY slowly (I mean, like an hour
or more at times!).  Any suggestions you can offer would be greatly
appreciated.
 
The report header contains 5 subreports.  The detail section contains 7
subreports.  Each subreport contains,on average, appr. 3 detail lines
and 1 total line. There are appr. 36 calculated fields per subreport.
There are 54 calculated fields in the detail section of the main report
--- SO, 36 x 7 subreports + 54 = 306 calculated fields in each detail
section of the report.  Each detail section is printed on a new page.
 
The report is often more than 100 pages.  There are appr. 20 tables used
in the various queries of the main report and subreports.
 
The client needs all of this info in one report.  It is their Proposal
that they submit when bidding on a contract, containing all of the labor
rates, fringe benefits, overhead, profit, etc. for each union trade and
level (i.e., carpenter foreman, carpenter journeyman, etc.) for straight
time/overtime/double time for first shift, second shift, third shift.
 
Help!  
Barb Ryan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030529/7db42d9a/attachment-0001.html>