Post reply

Export all reports in RDL format from SSRS Server Automatically

  • March 17, 2016 at 9:50 am

    #325724

    Hello,

    SSRS gives you the ability to export a report into the original RDL format: http://sql-articles.com/articles/general/download-export-rdl-files-from-report-server/

    What I am wondering is if there is a way to export all reports (via a command-line interface that I could write) or some tool into the original RDL format which can then be zipped up, etc.

    Thank you for your time.

  • March 17, 2016 at 9:58 am

    #1865915

    yes you can; google for "powershell extract SSRS"

    or just "extract SSRS" and you'll find quite a few solutions that query the ReportServer database and extract all the objects out.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 17, 2016 at 10:04 am

    #1865919

    Thank you; I didn't find this before when I searched.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply