Hi,
I am trying to make a report which groups together parents and their children. I have three levels.
I currently have three group headings and one detail section. I have some fields that are specific to the children that I have in details, and I have some fields which span all of the entries (regardless of parent or child)... My problem is that if I put these fields which span entries into details, there's a big space. If I put them into the group headers, they repeat.
Let me give an example:
Let's say my table looks like this:
Grandparent Parent Child GPAge PAge CAge Family
Grandpa Jones Dad Jones Boy Jones 65 45 15 Jones
Grandpa Jones Dad Jones Girl Jones 65 45 10 Jones
Grandpa Jones Bro Jones BroBoy Jones 65 40 5 Jones
Grandma Smith Dad Smith Girl Smith 70 40 10 Smith
Grandpa Smith Dad Smith Girl Smith 70 40 10 Smith
Grandma Right Dad Right 70 40 Right
I want to display these like this:
Name Age Family
Grandpa Jones 65 Jones
Dad Jones 45 Jones
Boy Jones 15 Jones
Girl Jones 10 Jones
Bro Jones 40 Jones
BroBoy Jones 5 Jones
Grandma Smith 70 Smith
Dad Smith 40 Smith
Girl Smith 10 Smith
Grandpa Smith 70 Smith
Dad Smith 40 Smith
Girl Smith 10 Smith
Grandma Right 70 Right
Dad Right 40 Right
The problem I'm having is that if I put FamilyName in the headers, I get family name even if there isn't a value. For example, where there is no child under the Right family, it would look like this:
Grandma Right 70 Right
Dad Right 40 Right
Right
If I put Family in the details section, it looks like this:
Grandma Right 70
Right
Dad Right 40
Right
The problem seems to be that there are multiple group headers, and they have specific data and general data in them...
thoughts?
Thanks!!
Lea Ann