SSRS Drill Down Help
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
June 22nd, 2012 1:27pm
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
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2012 2:41pm
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
July 15th, 2012 3:54am