Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, April 21, 2011 2:09 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

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.

Thanks


Post #1097234
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse