drill down report...without using drill down functionality in SSRS


  • I have to create a report as following:  Its very Urgent





    The above 4 are the hierarchies.

    Each hierarchy should behave as a drill down.....I have to write a stored proc...for that.

    At first the report show only Europe and all the RBU's...Then when I click any RBU--- It should display the Countries Below for the Selected RBU...Same with the Country....If I click the Country the Dealers under selected country should be displayed...

    Without using the drill down functionality in SSRS...we need to acheive it in T-sql...

    Appreciate ur help...

    Thanks u V Much..


    Friday, July 16, 2010 1:25 AM


  • Hi vineesh,

    If you are using PerformancePoint Services , decomposition tree as an interactive arrangement of bar charts that makes it easy to explore contribution relationships. It provides an effective alternative to the “Drill Down To” feature in analytic charts. While in Reporting service, I think we could only utilize the drill-down function to achieve this function effect, I am a little confused about how to achieve this using store procedure.

    Hope this helps.


    Challen Fu

    Tuesday, July 20, 2010 7:02 AM