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"
   $proxy = New-WebServiceProxy -Uri $ReportServerUri -UseDefaultCredential 
   $type = $proxy.GetType().Namespace
   
   #specify where the RDL file is 
   $rdl = "C:\SSRS\Customer Sales.rdl"
   
   #extract report name from the RDL file
   $reportName =  [System.IO.Path...