Error running report: Timeout expired

[jay@bplogix.com]

I am running a report against a SQL datasource that is very large. The report usually returns
Error running report: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
How can I tell the reports to increase the timeouts. Ideally I can do this from the connect string or configured somewhere in the report because I cannot change the code on this server.

Thanks!

[Alex K.]

Hello,

Please try to increase the value of the CommandTimeout property for the Data Source.

Thank you.

[jay@bplogix.com]

How can I do that if I cannot change the code on the server. Can I change this value editing the report properties in the report builder?

[Alex K.]

Hello,

Please try to set this property at the property grid.

Thank you.