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.