Need a solution,to stop generating report if it exceeds the time limit

Question

Hi,

I am running a report in report server,Its a big size report and taking more than 1 hr to get report.Please help me in stopping generating report if its take more than 1 hr.is any new features in sql server 2012 ssrs for this?

Answer 1

Hi John,

Please have look at this article from msdn - > http://msdn.microsoft.com/en-us/library/ms155782(v=sql.110).aspx

---

Regards Harsh

Answer 2

Hi Johnbastian,

If you mean the report server evaluates the execution time of a report and then determines whether to run the reprot or not, it cannot be done currently. If you want to limit the execution time of any report to one hour, you can refer to the link provided by Harsh to set the report timeout value to 3600 from the report manager.

Regards,   

---

Mike Yin
TechNet Community Support

Answer 3

I would first starting optimizing T-SQL query or stored procedure that generates report. Are  you sure you have properly defined indexes? How much data  does it produce? 

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance