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.

Hi, You, probably, do not need the second group for Child2. Have Child1 and Child2 in the same Child group, but sort the Child group the way that Child1 records go first. Remember to mark as an answer if this post has helped you.

dint get u :( lets take a simple example GrandParent_Group sum(value) Parent_Group sum(value) Child_Group sum(value) Now in my case the i want the Child to be subgrouped under GrandParent but it gets subgrouped under Parent

Then forget Parent and Child groups. Create new group called Composite_Group. If the record is parent then Composite field = 0 else 1.Remember to mark as an answer if this post has helped you.

Hi, From the discussion above, you may have some misunderstanding of the grouping in Reporting Services. Generally speaking, a group is a named set of data from the report dataset. At runtime, Report Designer combines and applies group expressions to data in a group. For example, below is the dataset. GrandParent Parent Child DataValue GrandParent1 Parent1 Child1 xxx GrandParent1 Parent1 Child1 xxx GrandParent1 Parent1 Child2 xxx GrandParent1 Parent1 Child2 xxx GrandParent1 Parent2 Child1 xxx GrandParent1 Parent2 Child1 xxx GrandParent1 Parent2 Child2 xxx GrandParent1 Parent2 Child2 xxx … … … … In the table, we can first add a group by the Child data field, and add a parent group to the Child group by the Parent data field. Then, add a parent group by the GrandParent data field. When the report renders, it will look like: GrandParent1 Parent1 Child1 xxx Child2 xxx Parent2 Child1 xxx Child2 xxx GrandParent2 … For more information, I would suggest you read the Adding Row Groups to a Table section at http://msdn.microsoft.com/en-us/library/ms159169.aspx Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.