10/04/2012

SSRS Excel Download Limation Due to Row Number Exceeded

There is a classic error which I tend to troubleshoot daily.

Exporting report in SSRS to Excel rows exceed the limit:

Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 145351, Max Rows: 65536 ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 145351, Max Rows: 65536 

What I typically let my users know is to download to .CSV format.

Our long term solution is to upgrade our Microsoft SSRS 2008 R2 to 2012.

However, there are several projects lined up before we can get to that.

On another note, SSRS 2012 downloads the Excel to .XLSX (Office / Excel 2010) so that solves other issues as well.

And there you have it!

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder