Post reply

Drill through/drill down in sql reports

  • August 27, 2007 at 1:30 pm

    #178246

    Can someone please suggest a way on how to use drill down in ssrs?

    Thanks a bunch!

     

  • August 27, 2007 at 3:32 pm

    #729659

    What do you mean Drill down?

    What are you trying to accomplish?

    you can for example call a subreport by clicking an item on your report.

    select properties on item, go to Navigation, then select what subreport you wish to call.

     

  • August 27, 2007 at 3:50 pm

    #729661

    I have to display the hierarchy level data. First, the VPs: you click on a node which will show a hierarchy of VP and again you click on one VP, which will show a series of RMs(Regional Manager) and under RM there will be details of some 5 and 6 stores sales data. This is for a chain of restaurants.

    I appreciate your help!

     

  • August 27, 2007 at 7:16 pm

    #729682

    Based on that description, the two "Visibility" properties, "Hidden" and "Toggle" are what you need to work with. Read up on them in BOL and you should find it fairly straightforward.

  • August 28, 2007 at 8:37 am

    #729798

    Thank you so much!! It worked!

    I had been trying through Navigation, jump to report etc...

    Yes, they are straightforward in BOL

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply