Good morning,
I'm trying to use the report viewer to display a web based report. I've already placed it on my server and was just running a couple of test inquiries with date parameters that designate what date range to display the reports, and any report > 2000 records begins to time out. I tried increasing the time out server side, and it's still giving me a problem.
My question is, is there way to prevent this issue? I am not doing a lot of sorting, filtering, or grouping. Essentially, my query is a basic Select with maybe one join in a stored procedure in SQL Server. I have used that as my data source and when I am pulling up the report the only two parameters that I give the report are a start date and end date.
The error that I am getting is always the following
[HttpException (0x80004005): Request timed out.]
Is there a way to resolve or prevent this short of just increasing the timeout to 3000 like I saw other people doing? I do not want to put too much overhead or load on the server. Another question, just to verify, Telerik does not "lock out" the records when I'm running the report viewer, correct? Since most of the reports that I have tried to run seem to take about 6 - 8 minutes to respond, I just want to ensure that I am not preventing other processes from accessing the same records.
Also, could it possibly be because of the multiple pages that the report viewer is rendering? I have it currently set to display only 22 records per page, but I forgot how to adjust that. So another question is how do I inform the report viewer that I want it to display more than 22 records per page?
Thank you in advance for your assistance.
I'm trying to use the report viewer to display a web based report. I've already placed it on my server and was just running a couple of test inquiries with date parameters that designate what date range to display the reports, and any report > 2000 records begins to time out. I tried increasing the time out server side, and it's still giving me a problem.
My question is, is there way to prevent this issue? I am not doing a lot of sorting, filtering, or grouping. Essentially, my query is a basic Select with maybe one join in a stored procedure in SQL Server. I have used that as my data source and when I am pulling up the report the only two parameters that I give the report are a start date and end date.
The error that I am getting is always the following
[HttpException (0x80004005): Request timed out.]
Is there a way to resolve or prevent this short of just increasing the timeout to 3000 like I saw other people doing? I do not want to put too much overhead or load on the server. Another question, just to verify, Telerik does not "lock out" the records when I'm running the report viewer, correct? Since most of the reports that I have tried to run seem to take about 6 - 8 minutes to respond, I just want to ensure that I am not preventing other processes from accessing the same records.
Also, could it possibly be because of the multiple pages that the report viewer is rendering? I have it currently set to display only 22 records per page, but I forgot how to adjust that. So another question is how do I inform the report viewer that I want it to display more than 22 records per page?
Thank you in advance for your assistance.