From the question
under timeout (in dataset):
Sorry to say this but the page referenced in the explanation does not match the Microsoft page:
SQL Server 2008 Books Online (November 2009)
How to: Create a Dataset (Reporting Services)
at:
http://technet.microsoft.com/en-us/library/ms160345.aspx
6. In Timeout, type the number of seconds that the report server waits for a response from the database. The default value is 0 seconds. When the time out value is 0 seconds, the query does not time out.
The above page does not correspond to the authors statement that 30 seconds is the default value......hmmmm
Now:
http://technet.microsoft.com/en-us/library/ms160345(SQL.90).aspx
SQL Server 2005 Books Online (November 2008)
How to: Create a Dataset (Report Designer)
Updated: 14 April 2006
It Says:
6. In Timeout, type the number of seconds that the report server waits for a response from the database.
The default value is 30 seconds. Timeout must contain a value greater than zero or be left empty.
If it is empty, the query does not time out.
Here we go again another big arguement/discussion on the quality of the QOD .... OH WELL