Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

report timeout Expand / Collapse
Author
Message
Posted Saturday, September 21, 2013 3:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:11 AM
Points: 152, Visits: 195
Hello,
I get a timeout after 10 mins on a report.
In site settings the option is set to report does not time out.
Question:
What setting on the report should be changed to avoid this timeout please?
There is also a timeout setting for the dataset oon the report which is set to 0 and not sure what it means when showing 0. Should this be changed for this purpose please?
Any other thoughts please?
Thanks
Post #1497127
Posted Saturday, September 21, 2013 7:43 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 2:19 PM
Points: 1, Visits: 21
Try to run the query behind this report in Management Studio and check how much time it takes to get the results.How many records this report will get from query? 10 minutes is really a long time, try to change the query if it is possible.
Post #1497141
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse