Pivot Table drill down feature in SSRS


  • My client has FoxPro reports & wanted to convert them to SSRS 2008. There is a report which likes Excel report Pivot table . It has drill down list as in link and can select all or deselect any items which I don't want to display.

    I have created the report through SSRS using Matrix and rendered it to Excel. But I don't know how to use this drill down (Filtering)  feature. Does SSRS 2008 support this ? Please let me know the way I can proceed .

    Really appreciate your help on this.

    Thank you,



    Wednesday, May 26, 2010 3:32 PM


All replies

  • You can try one of the following.
    1. If number of columns you want filter on is less than create parameter for each of them and constraint your query using WHERE clause.

    2. If number of columns you want filter on are more than return everything in report, export that to EXCEL and then select all and add filter.


    as per my knowledge, there is no direct way to export to excel with predefined filters.

    Wednesday, May 26, 2010 8:55 PM
  • Thank a lot.  Is there any way to add this pivot table filters programatically?
    Friday, May 28, 2010 1:55 AM
  • Hi Nandika,

    From the link you gave, I got that you might want to display or hidden the columns dynamically depending on the selection. We can achieve this in Sql Server Reporting Service as well. There is a similar thread you can click it at to get a reference from Sample for No.2 understanding  .Then export the report to excel.


    Challen Fu

    Wednesday, June 02, 2010 5:22 AM