Originally Posted 3 August 2016, 5:34 pm ESTGreetings, currently we're designing some reports using the Ad-Hoc designer. When built and tested they work fine although a bit slow (kind of obvious because they recover +65,000 rows minimum), but after saving to server and running them from reports dashboard they remain idle like for 2 minutes before an error message appears saying: "The operation has timed out." and nothing else.
We've set our database server to not time out commands (and in the model settings we've left the command timeout in blank because supposedly this inherits the provider settings) additionally our IIS configuration for time out connections have been increased as well but none of this seems to work.
Any ideas regarding the problem?, almost every report we use is large so this is a critical error for us.