Hi, I am using SSRS 2008 R2 tool for designing reports in our organization. The organization is using large amount of data for reporting purpose. I am facing error when I export the report to Excel as "Cannot export because exceeding 65556 rows". Since the export format is in Excel 2003, it is not allowing to export the report into excel. I came to know that SSRS 2012 addresses this issue but our Organization is not interested in updating to SSRS 2012. Please let me know if there is any solution to get rid of this without using any third party tool? I have read so many posts in almost all forums but didnot get a right approach regarding this. Appreciate your help! Thanks Kalyan P

Hi, You can do one thing you can set record per page next record will go next sheet see this No of record per page go to detail group properties and place this expression =Int((RowNumber(Nothing)-1)/ 65500) or you can have third party tool Aspose blog:My Blog/ Hope this will help you !!! Sanjeewan

Hi Sanjeewan, Thanks for the reply! I tried to implement the functionality as suggested but works only when I make the rownumber limit as 40000! Apart from that, when I implement this functionality, Report is splitting into multiple pages and in the first page I could see less no of rows (including hiding rows) which looks odd and customer will not accept this. Do you have any better idea to clear this issue? Thanks Kalyan P

Hi Kalyan, The maximum number of rows in a worksheet is limited to 65,536. If this is exceeded, the renderer displays an error message. This is a limitation when exporting Microsoft Excel as you said which you can see the details in the link below. http://msdn.microsoft.com/en-us/library/dd255234(v=sql.105).aspx#ExcelLimitations One workaround for this issue is as Sanjeewan said set page break. If this is not you want, I am afraid there is no other approach to work around the issue. If you have any concerns about this feature, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Regards, Charlie Liao

Hi, =Int((RowNumber(Nothing)-1)/65500). It will solve the excel limit issue but opens another issue. The issue you will face is this change will impact all the other formats like PDF, CSV etc to resolve this you visit this link Efficent way to handling Excel blog:My Blog/ Hope this will help you !!! Sanjeewan