O'Reilly logo

SQL Server 2012 with PowerShell V3 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 to the C:\SSRS folder. The sample RDL file uses the AdventureWorks2008R2 sample database. Alternatively, use an RDL file that is readily available to you. Be sure to update the RDL file reference in the script to reflect where your report file is located.

How to do it...

Here is how we can upload an RDL file to the Report Manager:

  1. Open the PowerShell console by going to Start | Accessories | Windows PowerShell | Windows PowerShell ISE.
  2. Add the following script and run:
    $ReportServerUri = "http://localhost/ReportServer/ReportService2010.asmx" ...

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