Hi I currently have a hierarchy report 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 SSRS? I've been trying to search for this solution for quite some time, but with no luck. Please help. Thanks

you can generate a sql query that will give you the reverse hierarchy as a result. which db you are connected with? sql server or oracle?

the db is sql server. So there is no way of getting this in SSRS at the report design level?

you can easily drag the (parent) level1 to the last row of that group from top. same for level2 drag to the below level3 group inside the last row of group level2.

Im sorry, if I was'nt clear. My dataset that I pull in from SQL is a hierarchy dataset with each record having a ParentNodeId and ChildNodeId(ParentNodeId is NULL for the top most node, and the ChildNodeId is null for the bottom leaf nodes) In SSRS, I have only one row group for the dataset. In the Advanced tab of group properties, in the Recursive parent option, I have selected ParentNodeId. This is what drives the hierarchical structure of the report. I understand what you(Hardik) were trying to say. But I have not created diffrent groups for each level. I have used the Recursive parent option to get this. So what I want to know is, using recursive hierarchy in SSRS, is there a way to get a drill up report (the top parent node at the bottom of the report, which drills up to its childnodes ) ? I hope this makes more sense. Thanks Deepa

I would suggest you to recreate the groups that you created in reverse order and place according to the requirement.Plz mark as Answer if your problem is resolved. Reddy

There are no multiple groups. Its just one row group with the recursive functionality.

the Level 2 and level 3 have been indented to be displayed in that format in the recursive hierarchy. Its not multiple grouping that I have used.

Deepa, let's say you have level1 that you can put at the last row in the group. now you want drill up from level1 to level2? then again level2 to level3? if you can separate out levels that means you have something called level column in your dataset. can't you use that column and make a separate group for the drill up thing?