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.

How to filter a report using an asp.net page

Hi,
I need to filter a single .rdl page in accordance with an option chosen from an asp.net page.
I know how to filter a report within the reporting page. But how can I do the filtering from an asp.net page? For example I have a Report1.rdl that prints out all the locations. I need the same report1.rdl page to print out only for a certain location based on the option I chose from the asp.net page. My asp.net page has 3 buttons. One to for all locations, another for location1, and the other one for location2. Please help. Thanks

1. Add a parameter to the report for location.

2. Modify your SQL code to account for that parameter, ie. WHERE Location = @.Location.

3. In Visual Studio, pass the location parameter value based upon the option chosen.

|||

GregSQL wrote:

1. Add a parameter to the report for location.

2. Modify your SQL code to account for that parameter, ie. WHERE Location = @.Location.

3. In Visual Studio, pass the location parameter value based upon the option chosen.

Thanks Greg. I got 1 and 2 working. Now how do I make the 3rd part? How do I call the parameters from an asp.net page to show the report in a browser? Thanks again for your help.
|||

Code Snippet

Dim param AsNew Microsoft.Reporting.WebForms.ReportParameter

Dim paramarr(0) As Microsoft.Reporting.WebForms.ReportParameter

param = New Microsoft.Reporting.WebForms.ReportParameter("myParameter", DropDownList1.SelectedValue.ToString())

paramarr(0) = param

ReportViewer1.ServerReport.SetParameters(paramarr)

This would set the report parameter myParameter to the selected value of DropDownList1. Remember that the parameterarray's starting index is zero...that typically leads me to off by one errors.

Oh and I was somewhat assuming that you already knew how to use a report viewer component in .NET to display a report in an internet browser. If not, let me know.