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

ssrs-2008 reporting-services ssrs-tablix ssrs-grouping
Somashekhar picture Somashekhar · Mar 13, 2012 · Viewed 21.9k times · Source

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

Jamie F picture Jamie F · Mar 16, 2012

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

Related questions

Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and …

Read More
How to hide parameter based on another parameter value in SSRS

Hi I have 2 parameters param1 and param2. param1 has values true and false.my requirement is if i select true in param1 then param2 should be hidden and if i select false in param1 then param2 should be visible. can …

Read More
Trying to Add Sub Row Group inside Parent but flush left in the nested cell

What I am trying to do: I am trying to create nested groups but I want the sub row group to show directly underneath the parent, flush to the left like the parent. So in this case You'd have: Market …

Read More