Report Response Times

Have a report written in SQL2005 that has 12 parameters, 3 of which are date
pickers. The client is complaining that once clicking on the link for the
report that it takes nearly 10 seconds to open the parameter page up. Does
anybody else have any probs with this sort of thing or does anybody have an
answer as to why it would take so long for the report to open.If a report has not been run in awhile then IIS unloads reporting services.
If this is what is happening then the second time any report is opened it
will open fast.
You can set the timeout period in IIS (this is an IIS thing, not Reporting
Services per se). Reporting Services is an asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nat Johnson" <NatJohnson@.discussions.microsoft.com> wrote in message
news:4B42CBAA-6BD5-4EAA-AE13-489E95EB6EAA@.microsoft.com...
> Have a report written in SQL2005 that has 12 parameters, 3 of which are
> date
> pickers. The client is complaining that once clicking on the link for the
> report that it takes nearly 10 seconds to open the parameter page up.
> Does
> anybody else have any probs with this sort of thing or does anybody have
> an
> answer as to why it would take so long for the report to open.