sql server reporting services: How to change query timeout? -- sql server reporting services

How to change query timeout?

ekkis
2/20/2007 11:06:08 AM

sql server reporting services:

I'm reporting from a web service that takes so long to return that Reporting
Services times out... how can I increase the timeout value when querying for
data?

RE: How to change query timeout?

Amarnath
2/20/2007 9:09:10 PM

Dont try to increase the timeout, instead optimize your query or use stored
proc.

Amarnath

[quoted text, click to view]

RE: How to change query timeout?

ekkis
2/21/2007 7:47:54 AM

perhaps I didn't explain myself correctly. I am reporting from a web service
so there are no stored procedures involved and the "query" is simply the
request to fetch data from the web service.

I have no control over the foreign server so I need to increase the timeout

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.