reporting services - Excel Export Fail when Number of rows in the Excel sheet exceeded the limit of 65536 rows ssrs

Question

In SSRS 2008 (I use Sql Server BIDS to create reports) how to solve "Excel Export Fail when Number of rows in the Excel sheet exceeded the limit of 65536 rows ssrs" issue

Thanks

Answer 1

Yes, this is a limitation of SSRS through 2008R2.

SSRS 2012, included with SQL server 2012 will remove this limit: http://blogs.msdn.com/b/farukcelik/archive/2012/02/01/sql-server-reporting-services-ssrs-reporting-services-in-sql-server-2012-codename-quot-denali-quot-will-support-xlsx-docx-formats-bye-bye-65536-rows-limit-in-xls-files.aspx

The workaround for 2008R2 and before is to export as .csv