Export to Excel does not render in SharePoint for large files

Vote count:

0

I have an SSRS report that has 50 columns and ~77,000 rows when run for a Plant (Distribution Center). This report shows inventory and relating statistics (which is why it is so large). When i attempt to export this from SharePoint it hangs for a very long time (<10 minutes) and then responds with "Sorry something went wrong". So i took a look at the file size which is only 3mb. I did some digging online and found that SharePoint has a maximum file size limit when exporting (our config file was set at 4mb). So i had our SharePoint administrator take a look. He increased the size to 10mb and the file still has the same exporting problem. I ran the same report for a different distribution center (with significantly less data. About 2000 rows) and the report exports fine. I set my report up as a subscription and the report export also fails. So i am wondering if there is a setting in the reporting server or SharePoint that will fix this issue.

asked 2 mins ago

Doug

1

Export to Excel does not render in SharePoint for large files