Post reply

Export To Excel

  • February 12, 2004 at 8:55 am

    #107054

    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??

    Cheers

    Mike

  • February 13, 2004 at 1:02 am

    #493948

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

    Here is the excerpt from RS Books Online

    ms-help://MS.RSBOL80.1033/RSMAIN/htm/rsc_architecture_v1_01df.htm

    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!

    Thanx

     

     

  • February 13, 2004 at 2:04 am

    #493957

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

    Thanks!! 

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

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