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.
| Author |
Topic |
|
schamp
Starting Member
13 Posts |
 Posted - 2010-11-01 : 03:02:24
|
| I have SSRS 2005 report.The report displays 10,000 of records successfully, but when the report is supposed to display lakhs of records, the report gets time-out.I have also tried the below changes but still the timeout occurs.1) In Report manager have selected the "Do not timeout report execution" option.2) In Machine.config changed the <processModel autoConfig="true" />to <processModel autoConfig="true" memoryLimit="120"/>3) In rsreportserver.config changed "MemoryLimit" and "MaximumMemoryLimit" to 120 and 160 respectively.Let me know what else can I do to avoid the timeout. |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-11-01 : 03:56:41
|
| Did you check SQL Server Time Out Settings ?Vaibhav TTo walk FAST walk ALONE To walk FAR walk TOGETHER |
 |
|
|
schamp
Starting Member
13 Posts |
Posted - 2010-11-01 : 05:17:45
|
quote:
Originally posted by vaibhavktiwari83
Did you check SQL Server Time Out Settings ?Vaibhav TTo walk FAST walk ALONE To walk FAR walk TOGETHER
How can I check those? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-01 : 11:55:46
|
| do you really need to show lakhs of records in report at any time?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
schamp
Starting Member
13 Posts |
Posted - 2010-11-02 : 02:05:21
|
| Yes |
|
|
|
|
|
|
Report TImeout