Reportins services Timeout expired

Question

Hi, I'm developing a Report Service and while excecuting the query getting :

An error has occurred during report processing. Exception has been thrown by the target of an invocation. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I know that on the SQL server the query running for a minute ot two.

I setted the Connection string in the web.config like that:

"Data Source=servA;Initial Catalog=myPortal;Integrated Security=True;connection timeout=1000"

It didn't work for me.

Answer 1

You can specify the connection timeout in the connection string, but that only says how long it should wait for a connection to succeed,

What you're looking for is the command timeout. That specifies how long SSRS will wait on a particular query to succeed. If I remember right, you can change this in each report in the command timeout setting? Or maybe it was called execution timeout?