I see that in the SQL Server Reporting Services 2005 Report Manager there is the capability to schedule reports for specific times (i.e. every weekday at a particular time).
What I would like though is more control — i.e. every weekday, but only between certain dates of the year — for example, getting sales figures every day starting 6 weeks before Christmas and ending 1 week after Christmas. There is a table that has the dates. How do I set that up in SQL Server Reporting Services 2005?
Best Answer
If you have Enterprise Edition you can create a Data Driven Subscription, whereby you generate a table of the report recipients and parameters and then point the report subscription to the table. You have complete control over how the table gets populated so you can make sure it only gets populated on the days you want the report to go out (the subscription would run every day but if the table is empty, it doesn't go out to anyone).