locked
SSRS SQL Server 2012 Version Export Issues RRS feed

  • Question

  • User306678366 posted

    We have a .NET web app running reportviewer in local mode (under SSL).  The reports render correctly, however when we export using the export the Export Dropdown Menu up in the toolbar area for xlsx or docx we are having problems (PDF works properly).  For Excel, the file downloads and shows on the local machine but give the error "Excel cannot open the file 'jaded.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

    Ctl Shift I displays the 101590 in the bottom right corner of the error dialog box.  We have tried renaming the file as xls extension, and renaming the file xlsb extension and opening with two different versions of Excel with no success. 

    We heard renaming it to a zip file and opening to see the contents.  That shows: [Content_Types].xml, .rels, app.xml, core.xml, styles.xml, workbook.xml, workbook.xml.rels and sheet1.xml.  The XML files all are valid xml.

    Not sure how to proceed to debug this one.

    Wednesday, May 27, 2015 8:20 PM

Answers

  • User1711366110 posted

    VastDomain

     The reports render correctly, however when we export using the export the Export Dropdown Menu up in the toolbar area for xlsx or docx we are having problems

      According to this case, there are new rendering extensions supported in SSRS 2012. those extensions are the OPENXML rendering formats, to be used with Word 2007/2010 (.docx) and Excel 2007/2010 (.xlsx).

    Note : both Word 2003 and Excel 2003 are technically still supported, but by default they are hidden from the export dropdown. The Excel and Word that we see in the export dropdown is the EXCELOPENXML and WORDOPENXML formats, which corresponds to the new .xlsx and .docx extensions.

    Check the Listed below :

    Name

    LocalizedName

    Visible

    XML

    XML file with report data

    True

    NULL

    NullRenderer

    False

    CSV

    CSV (comma delimited)

    True

    ATOM

    Data Feed

    False

    PDF

    PDF

    True

    RGDI

    Remote GDI+ file

    False

    HTML4.0

    HTML 4.0

    True

    MHTML

    MHTML (web archive)

    True

    EXCEL

    Excel 2003

    False

    EXCELOPENXML

    Excel

    True

    RPL

    RPL Renderer

    True

    IMAGE

    TIFF File

    True

    WORD

    Word 2003

    False

    WORDOPENXML

    Word

    True

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 28, 2015 10:47 PM