Hi K. Beckett,
Based on the error message, the issue may be a timeout issue related to the structured storage which is used as a container for storing binary Office documents. As I know, the structured storage is only used to store OLE objects or macros in Office Open XML documents. By default, SSRS 2012 use Office Open XML format when exporting a report to Excel. To check whether your report server uses Excel renderer (xls) or ExcelOPENXML renderer (xlsx), please export another report and check the file extension. If it’s an .xls file, it means that you have enabled Excel 2003 renderer for SSRS 2012. Besides, the name should be Excel 2003 in the drop down list of the Export option if you have enabled the Excel renderer in the rsereportserver.config file, and the EXCELOPENXML renderer displays as Excel in the drop-down list of the Export option.
So, if you are using the Excel renderer instead of EXCELOPENXML renderer, use the EXCELOPENXML to see if the issue persists.
If it is not the case, I suggest that modify the timeout value for the SharePoint Web Application and the report execution timeout.
References:
- http://weblogs.asp.net/jeffwids/archive/2010/09/04/how-to-increase-the-timeout-for-a-sharepoint-2010-website.aspx
- http://technet.microsoft.com/en-us/library/bb283188.aspx
Hope this helps.
Regards,
Mike Yin
TechNet Community Support
No comments:
Post a Comment