Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

Reporting on Hierarchical Recursive data using Reporting Services Expand / Collapse
Posted Thursday, April 21, 2011 2:09 PM


Group: General Forum Members
Last Login: Monday, October 15, 2012 11:29 AM
Points: 19, Visits: 60

I currently have a hierarchy report (using the Recursive functionality) with multiple levels that is a drill down from the top (parent) to bottom. Here is what I have right now:

Level1 - LV1Value LV1Value .....

----Level2 - LV2Value LV2Value .....

-------Level3 - LV3Value LV3Value .....

The users of this report have requested to get a drill -up version of the above format. This is what they want to see:

--------Level3 - LV3Value LV3Value

----Level2 - LV2Value LV2Value

Level1 - LV1Value LV1Value

Can this be achieved using recursive hierarchy in SSRS? I've been trying to search for this solution for quite some time, but with no luck.

Please help.


Post #1097234
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse