Hi,

I have an application developed in ASP.NET which reads the SSRS reports hosted at he report manager. For some report when I provide inputs to generate some huge reports (around 3500 pages), it gets generated and display properly on the report viewer control. However when I try export this result from the report viewer to a PDF, it time out after around 1.5-2 minutes. This is an RDL report. If I navigate directly to the SSRS reports page using IE, i.e. not via my custom ASP.NET application, I can generate the same report and also export to PDF without any issues.

I am using Report viewer version 10.0. .NET framework being used is 4.0

Following is my settings in the web.config file for my Custom application.

<system.web>
        <httpHandlers>
            <add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" />
        </httpHandlers>
        <compilation targetFramework="4.0">
            <assemblies>
                <add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
                <add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
                <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
                <add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
            </assemblies>
            <buildProviders>
                <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
            </buildProviders>
        </compilation>
        <authentication mode="Windows" />
        <customErrors defaultRedirect="~/WebPages/ErrorPage.aspx" mode="On">
            <error statusCode="404" redirect="filenotfound.htm" />
        </customErrors>  
    </system.web>

Hi Retheesh,

f SSRS is the backend server in which the reports are hosted, its possible you are dealing with 1 of 2 timeouts, the sessions timeout or the report execution timeout.  Check out my question i posted which includes some explanations of things as well as a link to a good article. http://social.msdn.microsoft.com/Forums/en-US/275b5741-0d0c-4be1-9aa5-05a8e363f991/how-timeouts-in-ssrs-2008-r2-work?forum=sqlreportingservices

If the reports are generating directly to PDF or Excel document, and not a web version first then users are clicking to export, its possibly the report execution timeout.  Otherwise you may be dealing with a session timeout.  A good place to start with trying to get some answers would the be the SSRS logs and the windows logs (system and application).

Add the <httpRuntime  executionTimeout="9000"/>.  in the web.config file