Reports with time out error
Hi, We viewed a report which was developed in reporting services. it showed time out error. I verified stored procedure which was used for this report. It gave output without time out error. But report showed time out error when we viewed report in our application. It showed time out error when we tried to view with large time span (it should generate 1600+ pages in report viewer). Stored procedure gave output without timeout error for the same parameter.How to solve this issue? Regards Senthil
October 28th, 2008 7:44am

Hi, Can you check the timeout valuefortheDataSet used in your report to call the SP? See http://msdn.microsoft.com/en-us/library/ms160345.aspxfor more details on where to find it. This timeout value is used when the underlying SqlCommand query (if you are using SQL Server as your DataSource) against your SP is executed. By default it should be 0 (no timeout), but it might have been changed when the report was built. Thanks, Andre
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2008 6:24pm

Hi, Thanks. We faced time out error due to more number of pages(1600+pages) in report viewer. How to solve this. We verified dataset sp is working without timeout error. Thanks Senthil
October 29th, 2008 10:01am

Hi, who wants to view 1600+ Pages? Use Filter. BanditTreiber
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2008 10:29am

I don't know your Datas, but how about a Cumulative Year-Viewand Drilldown to Month and/or Detailview of one Month(New Report). BanditTreiber
October 29th, 2008 10:58am

report has default timeout value (no timeout)Developer
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2011 7:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics