[AccessD] VERY SLOW report

MessageThanks, John..... I think that's a good idea.  I'll give it a shot!...........Barb
  ----- Original Message ----- 
  From: John Ruff 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, May 29, 2003 3:47 PM
  Subject: RE: [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 J 
  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


------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

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