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

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

We used filter with date range. If user choose the date range as current year, then it will generate 1600+ pages. I know, no one can view 1600+ pages. In our scenario, user want to view and take printout. Is there any solution for this problem(to view 1600+ pages in report viewer )? Thanks Senthil

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

Thanks BanditTreiber, I think it will help me. And one scenario we need to prepare statement for each person. if number of person increase(1600+ person ) , the number pages in report viewer will increase(1600+ pages). We need to display each person in different pages. Here we can not implement drilldown .... Thanks Senthil