Is there a way to change the Query timeout on all Datasets on all reports in a particular folder or on the whole site ? Thank you.

Hi RoshDsa, Please check these links:- http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/53a276e4-a480-4fb0-b101-e1145aa7bf9f http://blogs.msdn.com/b/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx Thanks KumarKG, MCTS

Thank you for the above links, but they point to Session Timeout on User Session or on a Data Source. That is not related to my question. My question is related to the query timeout that is defined in the Data Set properties of a report. Is there a way to set this for all reports ? Thank you.

Hi RoshDsa, Sorry for the confusion, are you looking for this:- http://msdn.microsoft.com/en-us/library/ms155782.aspx Use SQL Server Management Studio (SSMS).You can set the execution time-out for all reports. In SSMS, Right-click the name of a report server, then click Properties. On the Server Properties window, click the Execution page and change the value for Limit report execution to the following number of seconds. Please let us know your feedback. Thanks KumarKG, MCTS

That is one-way of doing it. But I was hoping for an automated way or high-level setting. I will have to go through 100 reports to change this. Thank you.