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

Downloading all SSRS report RDL files

This recipe shows how you can download all RDL files from your Report Server.

Getting ready

In this recipe, we will download all RDL files from the SSRS Report Server into C:\SSRS\ in a subfolder structure that mimics the folder structure in the Report Server.

Identify your SSRS 2012 Report Server URL. We will need to reference the ReportService2010 web service, and you can reference it using:

<ReportServer URL>/ReportService2010.asmx

How to do it...

Let's explore the code required to download the RDL files from your Report Server.

  1. Open the PowerShell console by going to Start | Accessories | Windows PowerShell | Windows PowerShell ISE.
  2. Add the following script and run:
    $VerbosePreference = "Continue" $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