When I try to export data of Report generated in SSRS 2005 and the data is > 65K then I am getting following error message:Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 88952, Max Rows: 65536 Is there any option to split the Excel sheet automatically while exporting is data exceeds more than 65K. Please suggest me the way to handle the same. In my report there is no grouping done.

Hi,Please check out this link which might answer your question: http://www.sqlservercentral.com/Forums/Topic485412-1063-1.aspxRegards,Raju

Hi,As Raju said, add a group to the table based on the row number. And then add a page break at the end of the group.By default, the Reporting Services export one page into one sheet in Excel. Another suggestion, please break page each 60000 rows, not 65000, although it is allowed to export 65000 rows to Excel. 50000 is better.That is used to avoid "Out of memorry" exception.Best regards,Jin ChenJin Chen - MSFT

Thanks Raju for this solution now I am able to do the paging and not getting the error.But still I am facing a issue that I am having Grand Total in Report Footer and it goes to next sheet as it is outside that group. I want to show the Grand total of all records at the end ofrecords e.g in my case I have done the paging after 50000 records and infirst sheet I am getting 50000 and in second sheet I am getting 30000 records and in third sheet I am getting one row showing the Grand Total.The solution provided by you solves my error related purpose but can you please suggest me some solution for the above mention problem coming now after implementing the same.

ThanksJin for this solution now I am able to do the paging and not getting the error.But still I am facing a issue that I am having Grand Total in Report Footer and it goes to next sheet as it is outside that group. I want to show the Grand total of all records at the end ofrecords e.g in my case I have done the paging after 50000 records and infirst sheet I am getting 50000 and in second sheet I am getting 30000 records and in third sheet I am getting one row showing the Grand Total.The solution provided by you solves my error related purpose but can you please suggest me some solution for the above mention problem coming now after implementing the same.

To the original poster- did you get any solution for the problem? On searching I have come across this thread and I am also facing the same issue. Could someone tell me if there is any workaround for this ? Regards, Karthik

I too am having this problem. Can somehow changing the ssrs excel version to 2007 be a solution?

Hi, As Raju said, add a group to the table based on the row number. And then add a page break at the end of the group. By default, the Reporting Services export one page into one sheet in Excel. Another suggestion, please break page each 60000 rows, not 65000, although it is allowed to export 65000 rows to Excel. 50000 is better. That is used to avoid "Out of memorry" exception. Best regards, Jin Chen Jin Chen - MSFT I followed this suggestion using 50000 rows per page break but I still get a system out of memory exception on a local machine with 2 gigs of memory on a report with about 100K rows. Does that sound right? Also the deployment server has 8gigs of ram so should that be enough?

My friend introduces one article about exporting data to Excel for me. After reading your question, I think that this article may be helpful for you. You can read it on http://www.c-sharpcorner.com/UploadFile/d0cbea/6031/?ArticleID=fbec7acd-cc67-470e-a760-f6475d255db7

The 64K row limit is due to the Excel BIFF format. One option to consider for current releases of Reporting Services is to export the report as CSV. If you then use Excel, create a new XSLX file and import from the CSV file, you can get more than 64K rows. HTH, RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.

to convert to xlsx you simply open the csv file inside of Excel where you can then save as an excel file.

to convert to xlsx you simply open the csv file inside of Excel where you can then save as an excel file.

Thank you for your response. but the Excel file is not formatted.K.Athma

Thank you for your response. but the Excel file is not formatted.K.Athma

Hi Robert Bruckner / All, I know how to export the report to CSV file. But I could not understand " If you then use Excel, create a new XSLX file and import from the CSV file, you can get more than 64K rows". How to convert CSV to excell? Thanks,K.Athma

Hi Robert Bruckner / All, I know how to export the report to CSV file. But I could not understand " If you then use Excel, create a new XSLX file and import from the CSV file, you can get more than 64K rows". How to convert CSV to excell? Thanks,K.Athma