SQLTeam.com | Weblogs | Forums

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

sql2008

#1

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)


#2

check if this may be helpful..
http://www.codeproject.com/Tips/860824/Using-Recursive-Hierarchy-Group-in-SSRS