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.aspxTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://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 ServicesGo to Report on Report ManagerClick properties of ReportSelect Download on the top right cornerNow you can open or Save the RDL filesSivaprasad S - SIVAhttp://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 |
 |
|
|