Good afternoon, When I click on ‘Export to Excel’ in Report, i get a File Download prompt and then I click on Save, you get the error. My report has at around 33K rows of data but while it tries to export to excel it tries to export 71K rows. Which is more than the no of rows MS Excel can accomodate. That means there are some extra rows are requested when it goes to export to excel. How to handle this? Thanks

I'm not sure that the number of rows is what is giving you the error. Try making a copy of the report (in Visual Studio) and reduce the number of rows in the data set to just a very few by filtering the data set. Then publish the copy and see if you still get the error when you try to export it to Excel. If you do not get the error with the reduced number of rows, the next question I would ask is; Are you hiding rows in the report, rather than filtering them out? If you are hiding them, look into filtering them instead, either on the dataset itself or at the group level. When you hide them, Excel treats them as hidden rows as well. Martina White

Hi Martina, i tried to apply filter (no. of rows returning are approx 10890. now it's fetching). Able to export the excel but unable to open that excel, it takes long nad then no response. Able to take export in .csv. I have the other reports in same server, those work fine for excel exports..

Hi xyz_chatter, Microsoft Excel is designed for data that has fewer than 65536 rows per sheet. Generally, we will reduce the amount of data we are using in the report or add page breaks to groups or report items to reduce the number of rendered rows per page. For more information, please refer to: Exporting to Microsoft Excel. In this case, could you please post both reports and the dataset with sample data to us by the following E-mail address? Then I will try to reproduce the scenario and assist you to resolve the problem. E-mail: sqltnsp AT microsoft.com (Please replace the AT with @, and remove additional spaces). Thanks, Bin Long