I have several reports in RS 2005 stardard edition and I've set up to cache those reports and expire the cache once per day. But the thing is they are quite big and everyday the first person who clicks those reports will suffer. I found a solution called "preload the cache" at
But that needs Data-Driven Subscription feature which is only available to Enterprise Edition.
I wondering whether there is a walk around solution to have the data-driven subscription available to RS 2005 standard edition(just like this article: http://www.codeproject.com/database/DataDrivenSubscriptions.asp
. But it's for RS 2000 stardard edition. I didn't quite get it)
Alternatively I'm thinking whether it's OK and HOW to create a program which could automatically "click those reports". The program could easily be scheduled to run by SQL Agent.