SQLTeam.com | Weblogs | Forums

How to create a Report with multiple Rows with One parent and multiple child groups



Hello Experts,
I am in a situation, where i am banging my head. I am in the process of creating a Report, and in this, i need ONLY the row groups (Parents and Child).
I have a Parent group field called "Dept", and its corresponding field is MacID.
I cannot create a child group or Column group (because that's not what i want).
I am then inserting rows below MacID, and then i toggle the other rows to MacID and MacID to Dept.

When i run i am getting this (As shown in the pic)


check if this may be helpful..