>>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.
Markus Egger's GenRepoX is supposed to do multiple detail bands. I've never tried it. There's a recent thread saying he has a new version out.