locked
Getting Error when exporting to Excel RRS feed

  • Question

  • Hi

    I'm getting the following error when trying to export to Excel in a report. Any help is greatly appreciated.

    Server Error in '/reports' Application.

     

    Runtime Error

     

    <!-- Web.Config Configuration File -->
    
    <configuration>
      <system.web>
        <customErrors mode="Off"/>
      </system.web>
    </configuration>


    Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

    <!-- Web.Config Configuration File -->
    
    <configuration>
      <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
      </system.web>
    </configuration>

     


    - Kerobin
    Monday, August 8, 2011 7:41 AM

Answers

  • Hi

    How many rows , columna re you getting when you view the report in web page.

    You may be reaching the limit of excel 2003 format http://msdn.microsoft.com/en-us/library/dd255234.aspx  look for excel limitations

    the most common ones are

    The maximum number of rows in a worksheet is limited to 65,536. If this is exceeded, the renderer displays an error message.

  • The maximum number of columns in a worksheet is limited to 256. If this is exceeded, the renderer displays an error message.

    Export to Excel 2007 format  was first introduced in  CTP £ denali 

  •  


  • Hope this helps , Robert Edgson
  • Marked as answer by KEROBIN Tuesday, August 9, 2011 11:58 AM
Tuesday, August 9, 2011 11:49 AM