Export SSRS Reports as .RDL files

fsilva-jr

Like ( 0 )

Report

Today i was forced to export some old reports from one messed up SSRS report server. Security configurations of this SSRS were all crazy and no one could clarify why. I was able to see some reports but could not see other one's... i could download some... but could not open other's...

The internet is really usefull if you look for the right thing!

First, go to the GitHub here: https://github.com/Microsoft/ReportingServicesTools

Download the file into your server, go to the PowerShell and run the .\install.ps1.

After that you can run the following command to export all the reports as a .rdl file extension:

#------------------------------------------------------

#Prerequisites

#Install-Module -Name ReportingServicesTools

#------------------------------------------------------

#Lets get security on all folders in a single instance

#------------------------------------------------------

#Declare SSRS URI

$sourceRsUri = 'http://servername/ReportServer/ReportService2010.asmx?wsdl'