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

2 thoughts on “Download Export RDL files from Report Server”

  1. 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.

Leave a Reply

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


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>