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 time out error Expand / Collapse
Author
Message
Posted Wednesday, June 26, 2013 7:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:09 AM
Points: 45, Visits: 111
Hi,

i am executing the report and it is taking 2 hrs and throwing error "Timed out".
i checked running all the data set queries individually in the back end and it is taking max 1 min for a dataset.

is there any way we can get the time taken by eaach dataset individually during the execution of the report?
Post #1467656
Posted Friday, July 12, 2013 7:19 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:09 AM
Points: 532, Visits: 447
How many datasets do you have, and what is the complexity of the report query and report layout. Many times the performance of a report can be assisted, by moving as much of the query to the database as you can, which may include firing a stored proc to populate a table, that you then query against locally. The more complex the report is, the longer it will take to render also.
Post #1473008
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse