Post reply

How to create same subscription across many reports

  • December 16, 2010 at 4:25 am

    #230884

    Hi guys - would really appreciate some help with this.

    I have 50 separate reports and I need to create a basic subscription to send these to a colleague each Monday morning.

    I was wondering is there any way that I can create a subscription to send reports to this person each Monday morning, and then 'apply' it to these 50 reports?

    If that is not possible please let me know. My alternative is obviously to go through and create separate subscription for each individual report but this is very inefficient and if there is a quicker way I would love to know about it.

    Thanks, DF

  • December 16, 2010 at 6:56 am

    #1263424

    You could use the SSRS web service to query your Report Server for all of your report and then create the subscriptions programatically by looping though your list of reports...

    Here's a link that shows how to create a single subscription, you'll just need to modify the code to fit your environment and usage. http://www.sqlservercurry.com/2009/07/programmatically-create-data-driven.html

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • December 16, 2010 at 7:35 am

    #1263452

    Thanks for the reply Luke L

    I am pretty new to SSRS and have no experience of programming outside of SQL, hence I don't think this solution will work for me.

    I was hoping there would be a way to do it via the RS functionality. Apologies my first post should maybe have been more specific.

    No matter I will simply build a subscription for each report.

    Thank you, DF

  • December 16, 2010 at 7:40 am

    #1263459

    Yeah unfortunately there's no easy way to do it. Directly from within the SSRS interface, though I imagine you could create a script and use RS.exe (check BOL for more info) as well.

    The nice thing is that if they all need to execute at the same time you can use the same schedule so it's one less piece you need to keep re-entering.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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