Deploying Reports With Powershell

Jana Sattainathan has created a few Powershell functions to automate dealing with SQL Server Reporting Services report deployment:

In this post, I want to publish a few functions that I created around SSRS. They are related to and depend on each other.

• Get-SSRS – Given the SSRS URI returns the WSDL endpoint

• Get-SSRSReport – Returns one or more reports based on inputs

• Get-SSRSSharedDataSource – Returns one or more shared data sources based on inputs

• Get-SSRSReportDataSource – Returns the data source information on a report by report basis based on inputs

• Set-SSRSReportDataSource – Sets the data source of a report to the given data source.

• Install-SSRS – Deploys an SSRS report to a specific folder and also optionally sets the datasource for the deployed report

Very useful.