Tom, I also have a report which encompasses 7 tables and 6 sub-reports. The stumbling block which I encountered at the time was having common column names amongst the tables for each sub-report. Once I did a schema change to make sure that all columns in the main and sub-report tables(except for the linking columns) were different, the report worked like a charm. You mention that the 11th sub is a multi-table view. You might try using alias names in the view to get away from common column names and give that a try. Hope this helps. Bill Eyring
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Tom Frederick Sent: Monday, August 17, 2009 5:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Subreports and limits I have a large report which has 10 subs that summarizes data for about one person. The subs are based on single (no breaks) or multi line (several breaks) views and the report works every time on multiple machines. There are many regions to allow text items to easily stretch. There have been several requests to incorporate an existing 'goals and objectives' report which means adding sub11 with a multi line view. When I do this the print process does not find sub11. The view is in the slave table list, the sub is shift relative to sub8, and listed as a sub. I can make a sub11 come up with plain text but any added data points stay empty. The data is in the view. Is there a limit to sub reports in terms of number, tables/views used, size, items used? Tried putting subs in regions and combining views where possible. Using v8 with latest updates and 2 meg memory. I can't see what I am missing since the other subs follow the same basic process and they work. There is a common ID# (ZID) for the person in all the views. The GoalIDs and ObjIDs are linked by the ZID and the GoalID. Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 O - 217-245-9504 F- 217-245-2350 Email - [email protected]
