Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Server Error On Exporting To Excel ON SSRS

Author  Topic 

aoriju
Posting Yak Master

156 Posts

Posted - 2009-07-15 : 01:56:59
Dear All,
I have an SSRS Report .It contains more than 20000 Records.I am trying To Export Into Excel it showing the Error Like Http Exception(0X80004005)-Time Out.I need a Urgent Solution For It.Please Help Me

Thanks & Regards
Riju A.O

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-15 : 03:48:57
There are some timeout settings in
Report Server. You can find them in the report server configuration file
(%SYSTEMDRIVE%\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer).

You can refer to the following article:
RSReportServer Configuration File
http://technet.microsoft.com/en-us/library/ms157273.aspx

Please try changing DatabaseQueryTimeout to 600 to see if it helps. By
default the timeout value is 120 seconds.


-------------------------
R..
Go to Top of Page
   

- Advertisement -