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

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 need to reference the ReportService2010 web service, and you can reference it using the following command:

<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 PowerShell ISE as an administrator.
  2. Add the following script and run it:
    $VerbosePreference = "Continue" $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