Deploy Rports using Script?

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  July 13, 2007 at 8:45 am

  #120747

  Hi all,

  How can i deply reports for SQL server reporting service using script! please advise!!

   

  thanks

  Pat

• Yelena Varshal

  SSC-Dedicated

  Points: 34287

  More actions

  July 13, 2007 at 9:30 am

  #719334

  You can use rs utility.

  http://msdn2.microsoft.com/en-us/library/ms162839.aspx

  http://msdn2.microsoft.com/it-it/library/ms152874.aspx

  Samples are in here:

  http://msdn2.microsoft.com/en-us/library/ms160854.aspx

  one of the samples:

  PublishSampleReports.rss

  Demonstrates a script that publishes the sample reports to a report server

  I did not use them yet.

  Regards,Yelena Varsha

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 16, 2007 at 2:04 am

  #719581

  If you use .net then you can create a datasource and then say which script is to be executed and then deploy the report.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com