Hi all. Is there any possibility for creating the recursive hierarchy groups using matrix control in ssrs 2008 r2. let me explain the scenarion in detail. I have three groups SBU, BU and SubBu in Rows and one group in column called location I need to provide the toggle condition on row groups so that when i click on SBu BU should open and when i click on Bu my SubBu should open. here comes the problem, my Sbu, Bu and SubBu are on the same row when all the three grouped are opened. i mean -Sbu -BU -SubBu But I want them to open in the hierarchy like - Sbu Sbu total -bu Bu totals - SubBu SubBu Totals I have used the inscope functions in my report, will they be disturbed if i change my BU and SubBu into the next rows. Please help me regrding this. Thanks in Advance. Regards, Balaji Prasad Balaji

Hi Balaji Prasad, It seems that you would like to create recursive hierarchy for your report, right? If in this case, I suggest you can alter the Padding property of the textbox properties, for more information, please refer to the following article, How to: Create a Recursive Hierarchy Group (Report Builder 3.0 and SSRS): http://technet.microsoft.com/en-us/library/dd255243.aspx If you have any question, please feel free to ask. Thanks, Eileen

Hi Eileen, I am using the matrix control in my report. So is it possible to create the recursive hierarchy. Please let me know if there is any possibility. cheers, Balaji PrasadBalaji - BI Developer

Hi Balaji, It is possible to use recursive hierarchy in matrix, please refer the following article and see if it works for you, Recursive Sum in a Matrix in SSRS 2008: http://blogs.microsoft.co.il/blogs/barbaro/archive/2009/10/23/recursive-sum-in-a-matrix-in-ssrs-2008.aspx Hope that helps. Thanks, Eileen