Copy .rdl from ReportServer - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Copy .rdl from ReportServer

Author

Topic

stormcandi
Starting Member

46 Posts

Posted - 2008-05-06 : 14:46:04

I have a report on the ReportServer that I need to copy to my local computer. It was not saved in SourceSafe. Is there a way to get the .rdl file for that report copied to my computer from the ReportServer?
I have googled the topic but no sites come close to what I want.

Thanks in advance!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-06 : 14:47:26

http://weblogs.sqlteam.com/tarad/archive/2004/05/18/1346.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

stormcandi
Starting Member

46 Posts

Posted - 2008-05-06 : 18:02:41

Tara, I apologize but I cannot find on the site where it shows the location of the .rdl files

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-06 : 18:06:31

You won't find them there. They get stored inside the ReportServer database in SQL Server. So you need to grab the rdl files from your source control or developer machine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

stormcandi
Starting Member

46 Posts

Posted - 2008-05-06 : 18:11:25

So if they are not in Source Control and no longer on the developer machine then they cannot be retrieved at all? That is the situation I am running into.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-06 : 18:41:42

I do not know if you can export the rdl from the ReportServer database. I'd suggest contacting Microsoft on that or googling for export options.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

stormcandi
Starting Member

46 Posts

Posted - 2008-05-06 : 18:49:30

Ok Thanks for taking a look at my problem for me! I appreciate it!

nsaini
Starting Member

1 Post

Posted - 2008-06-19 : 10:36:49

It is easy .....
Go to Report on Report Manager, Click properties of report, under the report definition you will see Edit and Update link...if you click on Edit you can open or Save the RDL files.

NKS

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 11:28:54

Did you find answer after 1 and half month?

stormcandi
Starting Member

46 Posts

Posted - 2008-06-19 : 11:43:59

quote:
Originally posted by sodeep

Did you find answer after 1 and half month?

I haven't tried nsaini's way yet. Other than what you see in this posting I have nothing new to report. I ended up having to recreate the reports.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-20 : 22:49:55

quote:
Originally posted by nsaini

It is easy .....
Go to Report on Report Manager, Click properties of report, under the report definition you will see Edit and Update link...if you click on Edit you can open or Save the RDL files.

NKS

Actually you have to click Show details and edit the report.

ahdubose
Starting Member

1 Post

Posted - 2008-09-23 : 17:49:34

Thank you to NSAINI! At least the answer was posted for those of us that encounter the same problem and are googling for answers! (even if it may not have helped the original poster in time, it did help us!)

ssivaprasad
Starting Member

9 Posts

Posted - 2011-08-12 : 22:21:20

For SQL Server 2008 Reporting Services

Go to Report on Report Manager
Click properties of Report
Select Download on the top right corner
Now you can open or Save the RDL files

Sivaprasad S - SIVA

http://sivasql.blogspot.com

Jerry444
Starting Member

5 Posts

Posted - 2011-11-23 : 16:52:55

For 2008 Reporting Services I would suggest this:

Mouse over a report and you'll see a dropdown.

Click the dropdown and click "Manage"

In the upper menu select "Download"

Click "Save" on the dialog to save the RDL file

jorn.vango
Starting Member

1 Post

Posted - 2011-12-13 : 09:50:15

I'm running into the same issue (SSRS 2005) where I need to make edits to an .rdl report.
I don't have Report Manager since SSRS is running in Sharepoint ... I can access http://localhost/reportserver (which shows me the .rdl file) but when I click on it, the report runs; it doesn't give me the option to edit ...

Any idea how to overcome this?

lkench
Starting Member

1 Post

Posted - 2012-09-28 : 08:02:01

quote:
Originally posted by jorn.vango

I'm running into the same issue (SSRS 2005) where I need to make edits to an .rdl report.
I don't have Report Manager since SSRS is running in Sharepoint ... I can access http://localhost/reportserver (which shows me the .rdl file) but when I click on it, the report runs; it doesn't give me the option to edit ...

Any idea how to overcome this?

I'm sure you've already moved on, but in case google brings anyone else here, probably the simplest solution in this scenario would be to go to the SharePoint Document Library where the reports are stored and open it up in Explorer view/mode; there are all your rdl files.

Be sure you disable automatically detect settings in LAN Settings in Internet Options, Connections tab or it will be SLOOOOWWW.

Even if you don't use Explorer mode, you will still be able to d/l the rdl files from the doc library.

Hope this helps,
Larry

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources