Export Error An error occurred during local report processing.

Asked By Fabian I Parks 10 points N/A Posted on - 04/01/2016

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

• Status: Open
• Question Views: 819
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Hardware

Answered By Sharath Reddy 590495 points N/A #184727

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);

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 06/03/2016
• Question Category: Hardware