Automating RS

  • I have a report where you select a Sales territory to run. Thing is there are 50 sales people. We want the report to go out every 15 days in e-mail. I set up a subscription and we can do that manually. Is there a way to script a report from the engine to create all 50 subsriptions easily?

  • Will a data-driven subscription not meet your needs?

     

  • There is a utility called "rs" that you can use to run VB.Net scripts against Reporting Services. I'm pretty sure you can use this to manage subscriptions. Look in BOL under "rs utility"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply