Hello, We got a requirement where we need to expand the SSRS report drilldown based on the User Level. We got 3 different level of Users (Regional, Distric and Store). The report will have mulitple Regions and each region will have multiple District and each district will have multiple stores. When ever Region1 Users logs-in, Region1 drilldown should be in the expanded mode and rest should be in the colapsable mode. When a district1 user logs in (member of region1) we should have region1 expanded and also district1 expanded. We are using recursive hierachy in the RDL. We tired to set the IntialToggleState as Dynamic, It hides all instead of colapsing. Pls give us your ideas. Thanks in advance. Regads, Frank

Check the following link. http://thavash.wordpress.com/2008/01/29/building-drill-down-reports-using-the-tablix-control/

Hi, First of all IniatialToggleState is only useful to set + or -. As I know you will have to work on the visibility tab. Under that 1)Go at Show or hide based on expression write your expression for EG "=IIf(Parameters!district.Value="district1",True,False)" And apart from that you will have to add one more fake column to give drill down as per district1,district2 etc.. Here is the link.. http://social.technet.microsoft.com/forums/en-US/sqlreportingservices/thread/179b832e-86b6-4e5b-8deb-a38fbf81ecce It will take some time but it works!!!Regards, Amey

Hi, As Amey mentioned you need to work on the visibility conditions in the groups along with toggle. For Regional group you can keep it as Visible all the time as you only have three types of users and this is the first group. For District group below is the visibility expression. =IIF(Parameters!userParameter.Value = "Regional", True, False) For Store group below is the visibility expression. =IIF(Parameters!userParameter.Value <> "Store", True, False) Hope its clear & helpful.... Pavan Kokkula Tata Consultancy Services.