SSRS Report Times Out

[dgillz]

SQL 2016, Report Builder 3.0. I have a report that keeps timing out. I have set the SQL server external query timeout in SSMS to no timeout, and I have set the timeout in the Report Server to " Do not timeout Report Execution". Yet my report keeps timing out.

The SQL itself that the report is based on runs in SSMS in 48 seconds. Am I missing a setting somewhere?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[fredericofonseca]

https://docs.microsoft.com/en-us/sq...-dataset-processing-ssrs?view=sql-server-2017

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886