I have a report with 21 datasets(each dataset will take less than 5 sec to execute except 2 which are taking 3-4 mints),the problem is I`M able to run my report in report manager,but same report am not able to run from web application,bcoz its seems to be timeout(after running its showing blank page).We went over to optimize those sections in the script but no use. Can anybody help me to how to resolve this issue,its an urgent one. early responses highly appreciated. thanks, @ng
The default timeout period of "DatabaseQueryTimeout" is 120 secs i.e. 2 minutes. So seems like 3-4 minutes queries are getting time out. You can change the timeout value for "DatabaseQueryTimeout" in RSReportServer.config file according to your needs. If that does not help, then please revert as there are some other factors to look into.