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)
 How to find my rdl filesn the sql server?

Author  Topic 

roy mm
Yak Posting Veteran

62 Posts

Posted - 2007-11-13 : 10:40:34
Hello.
I have a few reports that I've published to my reportserver.
Now, my rdl files have been delete from my local computer.

Is there a way to find the rdl files on the server so I can download them to my local pc so I can continue working on them?

I have full access to the report server of course (and the the sql server itself).
I'm useing rs2005.

Thanks.

tm
Posting Yak Master

160 Posts

Posted - 2007-11-13 : 16:40:47
You need to View your report on IE. Next to the View Tab there is a Properties Tab.Click on the Properties Tab and on the middle of the page there is an "Edit" link under Report Definition. Click on "Edit" and you will be asked to save the file. This is rdl file you need.

Go to Top of Page

roy mm
Yak Posting Veteran

62 Posts

Posted - 2007-11-14 : 00:19:19
Hi tm,

Thanks for your answer.

I also found a nice tool to do this (from the msdn ssrs forum):
http://sqldbatips.com/showarticle.asp?ID=62
Go to Top of Page
   

- Advertisement -