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