Post reply

Report giving timed out in application when the record count increases.

  • October 14, 2005 at 1:54 am

    #169357

    We are using SQL Reporting services 2000. We are having a report which has two subreports. When the record count is below 2000 then the report gets displayed and when the count is more than 2000 the application gives a operation timed out error. The main query takes around one minute to run in query analyser.

    During our R&D when we removed the sub-reports then application rendered 35000 records without any problem. But with any one subreport in the report it shows operation timed out.

    Can any one point out why this is being caused and what can be the probabable solution for this.

    Thanks in advance

  • October 17, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • October 17, 2005 at 8:58 am

    #597652

    Well, first of all, if we can, we should avoid using sub-report. Each report renders separately and impacts performance.

    Best thing you can do here is try to optimize your query so that it wouldn't take that long. Another WAY-OUT could be by changing value of "DatabaseQueryTimeout" key in "RSReportServer.Config" file found in "..\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer" folder. This value specifies the number of seconds after which a connection to the report server database times out.

    Hope this might help.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply