SSRS Export to Excel RRS feed

  • Question


    I created a report with multiple line per group and detail.  When I export the report to Excel it expands all of the drill downs.  Report with a single group and detail line exports to Excel and shows the drill downs for you to either expand or collapse.  Is there a way to have multiple group and / or details and have Excel show the drill downs?
    Tuesday, May 20, 2008 4:13 PM


  • Not in 2005. In 2008 MS rewrote the Excel export code and this will be retained with Office 2007 or greater.

    Tuesday, May 20, 2008 6:48 PM