Download Export RDL files from Report Server

Few days back I was working with one of my colleague with reporting service. I dont have much exposure to RS however its a simple task, he asked me to download a RDL file from the report server, we are using RS2005 and couldnt find download or export button which is supposed to be in different name. In this article we are just going to see how to download or export the RDL from your reporting server.

SQL Server 2005 and SQL Server 2008

  • Connect to Report Manager URL (ex: http://localhost/Reports_RS/Pages/Folder.aspx)
  • Browse to the RDL file folder or location
  • In this case Im going to download databaselist RDL file as shown below. Click on Show Details link in the page located on top right corner.

rdl_export_1

  • Now it will show the files in detailed view, now click on the Edit Button as shown

rdl_export_2

  • Now to download the RDL file click on the Edit button under Report Definition tab as shown. Your download window will now pop up.

rdl_export_3

SQL Server 2008 R2

In SQL Server 2008 R2 Microsoft has made this pretty straight forward.

  • Connect to Report Manager URL (ex: http://localhost/Reports_RS/Pages/Folder.aspx)
  • Browse to the RDL file folder or location
  • Click on the drop down menu near the RDL file. In this case Im going to download dblist file
  • Now just click on download button as shown, your download window will pop up now.

rdl_export_4


Posted

in

,

by

Comments

8 responses to “Download Export RDL files from Report Server”

  1. dinesh vishe avatar
    dinesh vishe

    Hi ,
    Great………

  2. selva.k avatar
    selva.k

    hi i am using sql server 2012, am download the rdl file in my location but the rdl file is not open. if open the rdl file i have the error message. the error message is “unknown error”.

    please help me open the rdl file.

  3. Luan avatar
    Luan

    Hi,

    Great post.

    is there any way to download batch?

    Tks;

    1. VidhyaSagar avatar

      I dont think you can download it as a batch

  4. Bala avatar
    Bala

    Need to down load entire folder not one by one ….

  5. murthy avatar
    murthy

    Good compilation of information

  6. James Polwort avatar
    James Polwort

    I do not get a download pop-up asking me where to save when clicking download. I click download, and “nothing” happens. ??

    1. VidhyaSagar avatar

      Which version? Pop up blocker?

Leave a Reply

Your email address will not be published. Required fields are marked *