Creating Report Subscriptions in MS SQL Server 2008 Reporting Services

Paul Litwin – Paul@deeptraining.com twitter.com/plitwin

In SSRS 2008 R2, right mouse click on a report to set up a subscription.  Any user who has rights to view a report can create a subscription.He advised you to migrate reporting server before migrating database server.

Maintain using the MySubscriptions page. 

Data-driven subscription.  Can do generation of distributions this way.  Delivery method you will be using (Windows File Share, Email, etc) will determine the type of query you need to run with your Data Driven Subscription.  File share DD subscription requires information to get to file share (UNC, user name, pw, etc).  Mail DD subscriptions require the fields that you might expect.

In SSRS R2, there is a new Cached Refresh Plan option to cache reports which take a long time to run.

Using SSRS Web Service to create report subscriptions.