- Joined
- Aug 24, 2006
- Messages
- 560
- Likes received
- 0
- Thanks received
- 0
- Location
- South England
Regarding the schedules - it's not difficult to write an app that can schedule reports for you in a more definable manner, including the ability to pass parameters to reports which require them.
This is actually one of the things I like about it, the URL access gives plenty of flexibility.
I've had to do this a few times already. Its not actually the scheduler which is at fault. That part works fine. We use BizTalk to generate business events, and if someone has subscribed a report to that event and the event says to email the report to a group of different email addresses each time, then you either have to manipulate SQL's job queue and Reporting Services underlying tables using ReportingService2005.asmx, or write your own PDF rendering service and implement that in conjuction with Reporting Services. Now, both are fairly easy, arbeit time consuming, but its still functionality that I'd rather have out of the box.