Automated deployment options for SSRS

reporting-services ssrs-2012
Michael Robinson picture Michael Robinson · Jun 2, 2014 · Viewed 11.8k times · Source

I have been tasked to look into ways to automate the deployment process for our SSRS 2012 reports. Are there any good tools out there? I'm thinking of something along the lines of press a button and the report gets deployed.

Thanks!

Answer

Ronnie Overby picture Ronnie Overby · Jul 23, 2015

To deploy our SSRS reports, we're using this lovely powershell project:

https://github.com/timabell/ssrs-powershell-deploy

Usage:

.\Deploy-SSRSProject.ps1 -path YourReportsProject.rptproj -configuration Release -verbose

or you can use the alternate parameter set:

.\Deploy-SSRSProject\Deploy-SSRSProject.ps1 -path .\AFS.Reports.rptproj -ServerUrl http://localhost/Reportserver -Folder MyReports -DataSourceFolder "MyReports/Data Sources" -DataSetFolder "MyReports/Datasets" -verbose

The full deployment story (for us):

  • ssrs-powershell-deploy scripts, .rptproj, .rds, .rdl files are all packaged into a nuget package by our build server.
  • Octopus Deploy extracts the nuget package on our SSRS server and calls Deploy-SSRSProject.ps1

Related questions

How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS 2008 R2 - SSRS 2012 - ReportViewer: Reports are blank in Safari and Chrome

I migrated our reporting services from version 2008 to another server version 2008 R2. In version 2008 the reports work fine on Safari. The new version 2008 R2 the reports do not show up at all. All I see is the parameter section and …

Read More
SSRS 2008 R2 - SSRS 2012 - ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8... why?

I have some simple reports in SSRS 2008 R2, but they won't display at all in Safari or Chrome. According to Microsoft's Books Online, these browsers are supported in limited fashion. However, I can't see anything after the data "Loading" clock …

Read More