Hi,
An error occurred during local report processing saying the number of rows exceeds the maximum possible rows per sheet. I don’t know how to fix this problem although I have a small excel sheet. Let me know the procedure to demolish this error. Thanks!
Export Error
An error occurred during local report processing.
Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 121320, Max Rows: 65536
Export Error An error occurred during local report processing.
It seems this issue mostly happens on Microsoft Office Excel 2003 due to the format of the report of the Reporting Services web service which Microsoft Office Excel 2003 supports. Unlike Microsoft Office Excel 2007 and Microsoft Office Excel 2010 which supports EXCELOPENXML, Microsoft Office Excel 2003 supports EXCEL report format. This behavior, according to Microsoft, is by design.
To fix this issue, change the report format in your application code from EXCEL to EXCELOPENXML. See the example below.
byte[] result = = (new ReportExecutionService()).Render("EXCEL", string DeviceInfo, out string Extension, out string MimeType, out string Encoding, out Warning[] Warnings, out string[] StreamIds);
To change the report format, it should be like this:
byte[] result = = (new ReportExecutionService()).Render("EXCELOPENXML", string DeviceInfo, out string Extension, out string MimeType, out string Encoding, out Warning[] Warnings, out string[] StreamIds);
