Report Designer report Export to Excel fails
Symptoms:
- "Export to Excel" function fails with the error, or
- User is experiencing "Unable to read file" issue intermittently when trying to open exported Report, or
- The "File Download" dialog appears but stays empty
Error/warning messages:
Export fails with the following error in UI:
404 - File or directory not found
Following line from the IIS log shows that the HTTP status code is 404 and the substatus code is 13:
POST /UserControl/CPGrid/CPGridExportToExcel.aspx …. 404 13
Reason:
Problem is casued by the size of the report to be exported. Substatus code 13 indicates that the content length is too large.
Resolution:
Edit your web.config file under the Enterprise folder, on each IIS server, as follows:
1- Find the “httpRuntime” tag, and add insert the requestLengthDiskThreshold="40960" parameter inside, and increase maxRequestLength E.g.
Line before the change:
Line after the change:
2- Find the “system.webServer” tag and insert the following tags and parameters between the lines:
Lines before the change:
Lines after the change: