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

Leave a Reply

Join the Conversation

8 Comments

  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.

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

Leave a comment

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

*


x

Related Posts

Batch Script to Deploy Multiple SQL files (Version 2)
I took very long break to keep the site up to date with my learning. Few years back I wrote an article to deploy multiple scripts using batch fi...
Provisioning Azure Cosmos DB using Powershell
Azure Cosmos database is one of the NoSQL database that is available in Microsoft Azure cloud platform. Azure Cosmos db is getting more popular c...
July 2017 CSSUG Meet
We are back in action for this month. Thanks to all the participants who visited the last event. We are pleased to update you all that this mont...
powered by RelatedPosts