O'Reilly logo

SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Uploading an SSRS report to Report Manager

In this recipe, we will upload an SSRS report (.rdl file) to the Report Manager.

Getting ready

You can use the sample RDL file that comes with this cookbook and save it in the C:\SSRS folder. The sample RDL file uses the AdventureWorks2014 sample database. Alternatively, use an RDL file that is readily available to you. Make sure to update the RDL file reference in the script to reflect where your report file is located.

How to do it...

These are the steps required to upload an RDL file to the Report Manager:

  1. Open PowerShell ISE as an administrator.
  2. Add the following script and run it:
    $reportServerUri = "http://localhost/ReportServer/ReportService2010.asmx" $proxy = New-WebServiceProxy -Uri $reportServerUri ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required