How to find my rdl filesn the sql server?

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.RS stores the rdl in the database. There is no rdl file on the server.
However, you can get the rdl file via report manager out of the database.
Not real intuitive on how to do it however. Go to report manager, click on
the report, then the properties tab. There is an Edit link under Report
Definition. Click on that, give it a directory on your local PC. Then open
up (or create) a report project. Right click on report and add an existing
item (this is from memory). Anyway there is a right mouse click menu for
adding an existing item. It will copy it over from wherever you put it into
the directory for your project.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nicknack" <roezohar@.gmail.com> wrote in message
news:1194968402.018507.270610@.19g2000hsx.googlegroups.com...
> 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.
>|||You can also get the rdl file from SQL Server Management Studio. Log on to
the Reporting Services service. Go to te folde where your report is
deployed. Right-click on the report and select Edit. You will prompted to
save the rdl file somewhere on your disk.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"nicknack" <roezohar@.gmail.com> wrote in message
news:1194968402.018507.270610@.19g2000hsx.googlegroups.com...
> 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.
>

How to find my rdl filesn the sql server?

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.

Hi there - this isnt documented very well, but you can actually just re-download the report directly from the report server

browse tohttp://reportingserver/reports

replace reportingserver with the name of your server.

click a folder - then a report to view it (like you were going to run it), then click the properties tab at the top.

About half way down the page, there will be an "edit" linkbutton, under the "Report Deffinition" heading, clicking that will give you the option to download the RDL

|||

That's great to know, because the rdl files do not exist on the reports server. They are in the database. I spent hours and hours trying to figure that one out. :(

|||

Hi Freakyuno.

Thanks for the reply. I get that question in a few other forum so I guss thats the way to do it :)

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

Still didn't try it out my self but I read about it and it sound like another way.

Thanks.