Larry,
A View is a nice feature, but also (in some way) quite dangerous. The results are not always as what you expect them to be. Why not creating temporary tables and make use of these in the subreport. If necessary you can create indexes too It is maybe not a straightforward answer to your question, but in this way you might be able to track and trace the whole process in an easy way. Tony From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: donderdag 24 maart 2011 20:03 To: RBASE-L Mailing List Subject: [RBASE-L] - Too Many Tables Defined in report. I have a report based on a view in which the detail section includes two subreports, each based on a different view. When printing the report, after a few hundred lines are printed I start getting the error -ERROR- Too many tables defined - Limit is 16000 (2137), followed by the Out Of Dynamic Space message. I'm not explicitly creating any tables in my report. I'm guessing that perhaps the subreports have to generate internal datasets to do their work, but if I cancel my report and list the tables in the database, I don't see any I don't expect, and I don't see 16000, or even close. Has anyone seen and perhaps solved this issue with "Too many tables defined" in a report with subreports? -- Larry
