May 15, 2009 at 5:04 am
Hi all
I have a feeling I'm missing something very easy here, but I can't figure it out...
I am trying to set up a report laid out as follows:
Grandparent
Parent1
Child1 Data item 1
Child1 Data item 2
Child1 Data item 3
Child2 Data item 1
Child2 Data item 2
Child2 Data item 3
Parent2
Child1 Data item 1
Child1 Data item 2
Child1 Data item 3
Child2 Data item 1
Child2 Data item 2
Child2 Data item 3
The problem I have is with grouping. The Parent group is correctly a nested group within Grandparent. The Child1 group is nested within Parent. What I want to do is have a second nested group within Parent, for Child2. Whenever I try adding a group, it gets nested within Child1, and that really makes the report a mess.
There's far too much data for subreports to be of any use.
If it helps, the stored proc returns the data like so:
Grandparent | Parent1 | Child1 |Data Item1
Grandparent | Parent1 | Child1 |Data Item2
Grandparent | Parent1 | Child1 |Data Item3
Grandparent | Parent1 | Child2 |Data Item1
Grandparent | Parent1 | Child2 |Data Item2
Grandparent | Parent1 | Child2 |Data Item3
Grandparent | Parent2 | Child1 |Data Item1
Grandparent | Parent2 | Child1 |Data Item2
Grandparent | Parent2 | Child1 |Data Item3
Grandparent | Parent2 | Child2 |Data Item1
Grandparent | Parent2 | Child2 |Data Item2
Grandparent | Parent2 | Child2 |Data Item2
Can anyone put me on the right track?
Thanks
Chris
Do not write in this space.
May 9, 2011 at 2:52 am
Did you find the solution for this?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply