CODEWITHSUNDEEP
reporting-servicesscriptingreportingservices-2005subscription
maxx777
maxx777

Reputation: 1330

Programmatically add subscription to SSRS reports

On my SSRS server I have folder structure like

I want to that these reports should be copied to client machine according to the same directory structure at a given schedule. I know this can be done by individually adding subscription to each report. But I was looking for a way so that I can programmatically ( using scripting or some tool) add subscription to all the report at one go. Also, if possible, it can be used for other clients as well in the future.

PS: I have searched on SO but the question appears to be old and does not solve my purpose either.

Upvotes: 1

Views: 2438

Answers (1)

MonkeyPushButton
MonkeyPushButton

Reputation: 1085

I believe it can be done using the SSRS web services the following steps are how I'd do it (sorry no time to code it for you):

  1. After getting a reference to the web service client, invoke ListChildren, supplying the recursive parameter to walk the directory structure.
  2. At each report node, call the CreateSubscription method, with appropriate parameters to dump to files.

Upvotes: 1

Related Questions