drill down to show the child in next column

[Ann]

I want to implement Drill down  on a particular hierarachy. Say Region. If I click region1, The districts of Region1 should appear as next column to Region1.

Any Clue how to implement this?

[RKMI]

Hi Ann,

I'm not sure if you can do it with drill down but you can do it by using a render variable with drill though to itself... where you create a hidden column and unhide when the region is click. I hope this makes sense.

I know it's also possible in an active report where you need to design use data decks to mimic a drill down... Drawback you can't export to excel, pdf...

Thanks,
RK