SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Copy .rdl from ReportServer
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

stormcandi
Starting Member

USA
46 Posts

Posted - 05/06/2008 :  14:46:04  Show Profile  Reply with Quote
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

USA
35937 Posts

Posted - 05/06/2008 :  14:47:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

stormcandi
Starting Member

USA
46 Posts

Posted - 05/06/2008 :  18:02:41  Show Profile  Reply with Quote
Tara, I apologize but I cannot find on the site where it shows the location of the .rdl files
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35937 Posts

Posted - 05/06/2008 :  18:06:31  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

stormcandi
Starting Member

USA
46 Posts

Posted - 05/06/2008 :  18:11:25  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35937 Posts

Posted - 05/06/2008 :  18:41:42  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

stormcandi
Starting Member

USA
46 Posts

Posted - 05/06/2008 :  18:49:30  Show Profile  Reply with Quote
Ok Thanks for taking a look at my problem for me! I appreciate it!
Go to Top of Page

nsaini
Starting Member

USA
1 Posts

Posted - 06/19/2008 :  10:36:49  Show Profile  Reply with Quote
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
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 06/19/2008 :  11:28:54  Show Profile  Reply with Quote
Did you find answer after 1 and half month?
Go to Top of Page

stormcandi
Starting Member

USA
46 Posts

Posted - 06/19/2008 :  11:43:59  Show Profile  Reply with Quote
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.
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 06/20/2008 :  22:49:55  Show Profile  Reply with Quote
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.
Go to Top of Page

ahdubose
Starting Member

1 Posts

Posted - 09/23/2008 :  17:49:34  Show Profile  Reply with Quote
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!)
Go to Top of Page

ssivaprasad
Starting Member

India
9 Posts

Posted - 08/12/2011 :  22:21:20  Show Profile  Reply with Quote
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
Go to Top of Page

Jerry444
Starting Member

USA
5 Posts

Posted - 11/23/2011 :  16:52:55  Show Profile  Reply with Quote
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
Go to Top of Page

jorn.vango
Starting Member

USA
1 Posts

Posted - 12/13/2011 :  09:50:15  Show Profile  Reply with Quote
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?
Go to Top of Page

lkench
Starting Member

USA
1 Posts

Posted - 09/28/2012 :  08:02:01  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000