Reporting on Hierarchical Recursive data using Reporting Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Asif Sayed » Reporting on Hierarchical Recursive data...

21 posts, Page 3 of 3

«««1 2 3

Reporting on Hierarchical Recursive data using Reporting Services

Rate Topic

Display Mode

Topic Options

Author

Message

deepa.devadas

Posted Thursday, April 21, 2011 2:09 PM

Grasshopper

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 »

21 posts, Page 3 of 3

«««1 2 3

Permissions