multiple destinations for reports using file shares with shared subscription

• rbond 51820

  SSC-Addicted

  Points: 422

  More actions

  June 27, 2011 at 1:35 pm

  #242868

  I'm a new user of SQL SERVER 2008 R2 Reporting Services.

  I've developed a number of reports we're trying to automate using shared subscriptions. All of the reports are being delivered to "file share" locations.

  My question is:

  Is there a way to deliver a single report to multiple file share locations?

  Ex.

  Report1 to be delivered to:

  File share location 1

  File share location 2

  File share location 3

  etc.

  Any assistance would be appreciated....

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 27, 2011 at 5:01 pm

  #1344903

  Yes. You can schedule a report to run multiple times with different parameters, formats, frequencies, and destinations.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/