Exporting SSRS Reports—For Free

Frankly, I would find it hardly worth the effort if I had to restore a single SSRS report and my only option was to restore the entire Reporting Services database. Thankfully, Jasper Smith has (apparently) mastered SOAP and the programmatic interfaces to SSRS and invented a free utility, Reporting Services Scripter, to suck out the RDL and Data Sources and all of the other catalog items from the database. I tried this utility and though it initially didn’t seem to support SQL Server 2008 (2.0.0.0.11), I was able to get it to connect to my SQL Server 2008 instance and script out the reports as well as create a Visual Studio BI project for each directory. This saved me the worry and trouble of propagating my test reports to another system. You can download the utility off the web.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish