Export To Excel

  • Hi

    I'm currently trialling the Reporting Services on SQL Server 2000, but when I try to export a report to Excel all I get is a load of code and characters in the Excel export and not the original data I was viewing.  This happens when I export from within the designer in .NET and from the Report Manager.

    Any ideas anyone??



  • What version of Excel are you using? Its requirement is Excel 2002 or higher.

    Here is the excerpt from RS Books Online


    Excel Rendering Extension

    The Excel rendering extension renders reports that can be viewed and modified in Microsoft Excel 2002 or later. This rendering extension creates files in MHTML, which carry a MIME type of ms-excel and contain HTML meta tags and XML data islands that are specific to Excel. While the Excel rendering extension renders HTML, the rendered report is intended to be viewed in Microsoft Excel, not in a browser.

    Resources, such as images, are embedded within the report. For more information about designing reports for the Excel rendering extension, see Designing for Excel Output.

    Hope this helps!




  • That'll explain the problem as we are currently still using Excel 2000!!


Viewing 3 posts - 1 through 2 (of 2 total)

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