Hi all, In my dataset I have the following column Sort Order 1 1.1 1.1.1 1.2 2 2.1 2.2 2.3 3 3.1 Of course there is additional columns but what I want to do is hide (drill down) all children of each parent so the report would start out: +1 +2 +3 But then could be expanded to: -1 +1.1 +2 +3 I was wondering if someone could help with this. There are an unspecified number of children for each parent. In Theory I could have a 1.1.1.1.1.1.1 etc. etc. Which means n number of drill downs. Thanks So Much

create an expression using the length of the sort order field, group when length =1 , something like =len(Fields!Sortorder) then set the visible property to false for the 2nd and 3rd columns HTH DeanDean MCTS-SQL 2005 Business Intelligence, SharePoint 2010, Configuration

Hi JoshBellInTx, I suggest you that refer to the following articles to design the drilldown report, please see: Hide an Item (Report Builder and SSRS): http://technet.microsoft.com/en-us/library/dd220590.aspx Add an Expand/Collapse Action to an Item (Report Builder and SSRS): http://technet.microsoft.com/en-us/library/dd220405.aspx Regards, Bin LongBin Long TechNet Community Support