>I spent all day yesterday trying to figure this out. Any help will be much appreciated.
>
>I have one parent table and 11 child tables. (My app uses parameterized views rather than related tables, but I'm willing to relate the tables to get the report to work.) I want to produce a report that shows the parent table info at top, then the child table info from each of the tables like this:
>
>Parent record1 field1, field2, etc.
>
> Child1 Record 1 ...
> Child1 record 2 ...
> etc.
>
> child2 record 1 ...
> child2 record 2 ...
> child3 record 3 ...
> etc.
>
> child3 etc
>
>Not every child table has a record, so I guess I need to do left joins in a SELECT statement. But no combination of SELECTs and data groupings I could think of produced the correct results. Is there a basic strategy for accomplishing this?

Ross:

There have been several threads regarding reports needing multiple detail bands in a report which is basically what you are needing. Their were several *workable* solutions but they all fairly much involved combing all data into 1 view, cursor, etc. I do not think this very practical in your case of 11 child tables. First I suggest searching the Report Designer category for the previous threads. With that many child tables, producing the report strictly by hand-coding may be the easiest and most accurate way.