Tom: I agree with Bill. Another thing to try, if this report will only be run through program code, is to replace the 11th view with a temp table and load it with your data. See if that makes the data appear. Test it by creating a temp table with just your common column and one or two extra columns to start with.
Karen > 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 >
