Sounds like pulling from a view creates a new hidden temporary table each time the view is hit. Also, you are pulling from the database every time the view is hit. Creating a temporary table one time is more efficient. I'll bet your report runs a lot faster. If you index an appropriate column in the temp table, it will go even faster.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Friday, March 25, 2011 8:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Too Many Tables Defined in report. I'm taking the extra step of projecting my views out to temporary tables and basing the report on the tables instead of the views. This trick seems to work around my problem from yesterday. Yesterday my report would start failing around page 92, today I am able to print the complete 112 page report. Thanks for the help! -- Larry
