I have a situation where I've got a tables engaged in one-to-many parent-child table relationships. The children themselves are parents with many child relationships of their own. The way I've handled simple, single level one-to-many reports in the past is put the fields from the parent into one report band, and the fields from the children in the detail band. But how do I go about doing two or three tiers of this?
Let me try to explain this another way.
PARENT
...One-of-Many-Child-Type-1
........One-of-Many-Child-Type2
........One-of-Many-Child-Type2
........One-of-Many-Child-Type2
........One-of-Many-Child-Type3
........One-of-Many-Child-Type3
........One-of-Many-Child-Type3
...One-of-Many-Child-Type-1
........One-of-Many-Child-Type2
........One-of-Many-Child-Type3
........One-of-Many-Child-Type3
...One-of-Many-Child-Type-1
........One-of-Many-Child-Type3
...One-of-Many-Child-Type-1
........One-of-Many-Child-Type2
What I need is a list of the Parents. I figured I put this in its own report band. But after each parent, what I can't figure out how to do is list fields from all the Type-1 records, followed by its children Type-2 and Type-3 records. Does this make sense to anyone and do you have any suggestions on a technique to make this happen? Help! I'm stumped.
Please and thanks for the help.
Ernie Veniegas
Micro System Solutions
... sensible software by design