Hierarchical Drilldown Report
Hi all,
Hope somebody can help me with this. I am trying to create a drilldown report in SSRS 2008. When I add the groups, the groups are added to the right of the parent group; however, what I want to do is create a hierarchical drill down. In other words,
instead of going to the right, the groups will appear under the parent, within the same column.
Any help would be greatly appreciated.
Thanks in advance.
April 14th, 2011 8:53am
In the group pane below, right-click on the parent group and go to Add Group->Child Group. Hope that helps.
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 9:31am
Hi ,
Check link
http://msdn.microsoft.com/en-us/library/cc627469.aspxRegards, PS
April 14th, 2011 9:46am
Shahfaisal,
Thanks for your reply,
Whe I add a Child Group, a new columm is added to the tablix; however, I want the child group to appear as a new row, not a new column. In other words, under the parent group.
Thanks.
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 3:27pm
Shahfaisal,
Thanks for your reply,
When I add a Child Group, a new columm is added to the tablix; however, I want the child group to appear as a new row, not a new column. In other words, under the parent group.
Thanks.
April 14th, 2011 3:30pm
When you add a child group, check the option to "add group footer". You can delete the new "Group column" if you don't need or have the group column and delete the actual column itself. Is that what you are looking for?
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 9:29pm
Below is an image of what I am trying to accomplish. This is from a training video that I am watching. Unfortunately the video does not explain how this is accomplished.
Thanks.
April 14th, 2011 10:08pm
Anybody else that would have an idea on how to accomplish this?
Any help would be greatly appreciated.
Free Windows Admin Tool Kit Click here and download it now
April 15th, 2011 9:18am
Hi.
Check the link below. Which cleary explain the thing you want to achive
http://sql-bi-dev.blogspot.com/2010/09/groups-in-ssrs-2008.html
Regards, PS
April 17th, 2011 8:46am
Thanks Pritam.
That is what I was looking for.
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2011 8:56am