Last post Jan 14, 2009 08:42 AM by Nai-Dong Jin - MSFT
Jan 08, 2009 07:22 PM|rayabharapusuman|LINK
I have ran into the below error because of bulk and huge data. The error is given below:
"Error: System.Exception: Excel Rendering Extension : Number of rows in the Excel sheet exceeded the limit of 65536 rows. Message: Excel Rendering Extension : Number of rows in the Excel sheet exceeded the limit of 65536 rows. (Internal) Stack inner exception
generated an error."
I know that the error is caused because of the more number of rows exceeding 65536.
Now i want to know how can i handle that in the SSRS 2005. I have a tabular report with header, details and footer section.
I tried assigning "=Int((RowNumber(Nothing) - 1) / 20)" as the expression when i right clicked on details section and selected the edit group option. And when i try to run this i get 9 pages becuase i have 175 records and the strange thing is only the first
record is shown per page. And the sheet is broke in excel.
I donno why all other columns in the detail section are invisiible except the first record per page. only 1 record is shown out of 20 records and 21 out of 40 in second page and goes on.
If the records are visible my problem is solved. I will just replace that with 65536 so that the maximum number of records in excel are reached and then page break is applied. I dont know why are the data invisible.
Please tell me why the remaining items are getting invisible.
Any help would be greatly appreciated.
Jan 13, 2009 04:03 PM|TATWORTH|LINK
This is an Excel limitation - please see
For more information, please see the Microsoft Office forums at:
Jan 14, 2009 08:42 AM|Nai-Dong Jin - MSFT|LINK
I'm not sure how you handle with your paging in your report, but it seems the root cause of the problem is the 65536 limit in Excel, right?
I suggest that you can add page break manually in your report after several rows (page size), since SSRS uses page breaks to split data up onto tabs, so you could achieve it by creating a report containing a rectangle. Set the rectangle to have a page break
after. Another practice is to use a macro to open the file and automatically break the text into multiple worksheets.
For more information, you can see: