SQL Server Reporting Services proxy timeout (ASP.NET)
- by Philip
Morning,
We are using SSRS (2005) and have a ASP.NET frontend using the SSRS WebControl.
I've boiled the problem down the time it takes for one particular report to be generated is greater than the timeout on the proxy server.
It looks like the way the SSRS web control tries to do things is by performing an HTTP request for the report, however the problem with this is the request can timeout potentially before the report has generated. Looking at the HTTP traffic the response is a 504 (gateway timeout).
Is there a way to increase the timeout or change SSRS WebControl to use more robust polling mechanism (which isn't dependant on the timeout of the HTTP request).
I could be wrong but I don't think ServerReport.Timeout property would resolve the issue we are seeing?
Any thoughts?
Philip