We are generating excel report using report viewer at run time but if excel report having more then 65000 record generating error Microsoft.ReportingServices.OnDema ndReportRendering.ReportRenderingE xception: Excel Rendering Extension: Number of rows exce

We are generating excel report using report viewer at run time but if excel report having more then 65000 record generating error Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceed.

what will be best solution for this one.

we are using .rdlc report

April 28th, 2015 8:58am

We are generating excel report from report viewer in .xls format and fill size is too large so what is the best way to reduce the file size. 

we are using .rdlc report and using report viewer at run time report are coming in .xls format.

Free Windows Admin Tool Kit Click here and download it now
April 28th, 2015 9:00am

You have split the first 65000 rows in to a sheet1 and remaining rows should go to sheet2. Then you will be able to generate excel file with data. Use pagebreak option to split data in to two sheets in excel. Please check the below link for more information

http://social.technet.microsoft.com/Search/en-US/?query=excel%2065536%20page%20break&rq=meta:Search.MSForums.ForumID(055ccfc1-78f5-46ff-8171-33f8ff760a7c)+site:microsoft.com&rn=SQL+Server+Reporting+Services+Forum

https://msdn.microsoft.com/en-us/library/dd255234.aspx?f=255&MSPPError=-2147217396

April 28th, 2015 4:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics