Sharepoint Integrated SSRS report excel export fails
<p>When trying to export a report to excel, the web site loads for some time and I am getting "This page can’t be displayed. Make sure the web address is correct" error.</p>

<p>Here are some platform details:</p>

<ul>
<li>SQL Server 2012 with SP2 </li>
<li>Sharepoint 2013 </li>
<li>SS Reporting Services with Sharepoint Integrated Mode </li>
<li>Windows Server 2012 R2</li>
</ul>

<p>The report itself has 4-5 parameters, calling some views and one procedure, and displays 120K rows with 30 columns max. The whole report without filtering can execute in about 7 seconds in SSMS. SP website can display the results of rdl just fine, report displays fine and fast enough. I can also export the results to csv, xml, all 120K rows of it. But when it comes to exporting to excel, it gets stuck.</p>

<p>Now this is where it gets funny. </p>

<p>When called with some parameters or date filtering, the report comes out nice and easy and can be exported to excel without delay. I have tested with increasing number of rows and excel export works fine up to some 50K rows. The exported xlsx file is around 9MB. But when I increase the date range, excel export is timing out. </p>

<p>Now on to the things I tried.</p>

<p>Exporting to other formats work fine. Just EXCELOPENXML is not working.</p>

<p>Increasing the values of <em>ProcessTimeout</em>, <em>ProcessTimeoutGcExtension</em> and even adding <em>DatabaseQueryTimeout</em> keys in <strong><em>rsreportserver.config</em></strong> did not help.</p>

<p>Increase the values of <em>executionTimeout</em> and <em>maxRequestLength</em> keys in <strong><em>web.config</em></strong> also had no effect.</p>

<p>I restarted Reporting Server services after config changes.</p>

<p>I suspected the 10MB excel export bug in SQL 2012 but that should be resolved with SP2 which is applied in this system.</p>

<p>Also related, few minutes before displaying the error message, web site asks for a re-login to sharepoint site. That happens after a couple of minutes of hitting the excel export. I want to make sure everything is what is supposed to be in sql side before making any IIS config changes. </p>

<p>Any ideas?</p>