Export Chart and Underlying Data to Excel RRS feed

  • Question

  • We are builing a reporting application for our customer, and the customer has asked us to export the SSRS reports into excel - which is very straightforward.

    However, the customer wants to include the chart AND the underlying data that builds the chart exported to Excel, so they could have the ability to manipulate the Excel data and influence the chart (after the exporting process)

    Does anyone know if this ability is available in SSRS?  We are using SQLServer 2005.


    Thursday, March 19, 2009 2:27 PM


  • Charts are exported as images only in Excel.  You could export the data by creating a table that the chart is based on in the report, but the user will have to recreate the chart in Excel. 

    You may want to look into SoftArtisans at http://officewriter.softartisans.com/officewriter-250.aspx

    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    • Proposed as answer by Sean Boon Thursday, March 19, 2009 5:06 PM
    • Marked as answer by Raymond-Lee Friday, March 27, 2009 6:07 AM
    Thursday, March 19, 2009 5:06 PM