When Exporting Large Data from SSRS Report to Excel, Getting Error Message as Request Timeout in Sharepoint 2013

Introduction

This tip will help you to resolve the request timeout error when you export the data from SSRS report to Excel.

How to reproduce the issue:

1. Navigate to SharePoint Site--> library where you hosted SSRS report
2. Click on the report and select Actions-->Export to Excel
3. Then, the report will take some time and returns error message as "Request Timeout"

Solution

To fix this issue, we need to make change on the web.config file. Please follow the below steps:

1. Open web.config file from: Drive:\inetpub\wwwroot\wss\VirtualDirectories\Virtual Directory Name
2. Take a copy of existing web.config file
3. Add the below entries in web.config file, You need to set the SharePoint site timeout from 110 seconds to 9000 seconds <httpRuntime maxRequestLength="100000" executionTimeout="9000" />
4. On SP app server, open web.config file from: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\Reporting <httpRuntime executionTimeout="9000" maxRequestLength="409600" />

History

• 5^th July, 2016 : Initial version created