One of the most irritating things about SQL reports is that it falls asleep every now and again. The user experience is not pleasant and resultant calls to technical support or worse still loss of end-user customers.
I have tried altering rsreportserver.config setting the ProcessTimeout to a figure of 30000 but that did not seem to do anything. Is there limit on this number or even better and infinite value ? Once up and running SQL reports works OK, not sparkling - I swear the old FoxPro reports & even dare I say it Access ran rings round it, but this falling asleep on the job is giving me the real gyp. -- ----------------------------------------------------------------------------- Stuart Kinnear Mobile: 040 704 5686. Office: 03 9589 6502 SK Pro-Active! Pty Ltd acn. 81 072 778 262 PO Box 6117 Cromer, Vic 3193. Australia Business software developers. SQL Server, Visual Basic, C# , Asp.Net, Microsoft Office. -----------------------------------------------------------------------------
