Report Group Header vs. Detail difficulty

[lmawler]

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

[lmawler]

Sorry about the confusion of the first note... formatting came out all wrong... I'm not sure how to get the formatting across, so I'm trying to spell it out this time...

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.

Say I had a table with columns: Grandparent, Parent, Child, GPAge, PAge, CAge, and FamilyName.

Only FamilyName (in my example) would be shared across parent, child, and grandparent.

Then, I want to report on them so that grandparent, their age, and their family comes out on line one, all parents associated with the same grandparent come out on the next line, each with their age and family, and then children come out under their parents.

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 a row with a grandparent and a parent, but no child it would print one row with gparent, gpage, and family, the 2nd row with parent, page, and family, and the third row with just family.

If I put Family in the details section, it looks like this, then the first row has gparent, gpage, and a blank. Row 2 has blank, blank, blank. Row 3 has blank, blank, familyname. Same for parent.

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