You receive the following when attempting to launch a large report within SQL Reporting Services in Sharepoint integrated mode + Project Server 2007:
Server Error in '/' Application.
Request timed out. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Request timed out.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: [HttpException (0x80004005): Request timed out.]
Extend the timeout value in the web.config file of the Sharepoint web application. Visit the web.config file located within the IIS website (e.g. c:\inetpub\www\website\80), edit the file and search (CTRL F) for "httpruntime". Modify the line from:
httpRuntime maxRequestLength="51200" /
httpRuntime maxRequestLength="51200" executionTimeout="9000" /
Adding the executionTimeout line will extend the default 2 minutes of generating the report to 10 minutes +
Close down your web browser and regenerate the Reporting Services Report (in my case, integrated with Project Server 2007 with Sharepoint) through the Sharepoint website/web application. The report should now be successful!