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.
| Author |
Topic |
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
 Posted - 2009-06-17 : 13:06:35
|
| Being new at Report Server, I don't know how to get into the previous developers reports. They are on the Report Server website and they run when clicked on, but I want to open them in Business Intelligence (that is the correct program, correct?) and first of all, see how they are created, second of all, revise them, and third of all, use them as models for new reports.I tried clicking on the ReportBuilder icon on the site, but when the program came up, it told me there was no data model. I also found a way to pull one of the report .rdl files off the site and opened it in Business Intelligence and it just looked like some XML type gibberish.Please help me to uncover this mystery. Thank you.Duane |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 13:23:28
|
| you need to open business intelligence studio and then start reporting services project. then import rdl files from your report server to local machine and open it inside reporting services project. then you will be able to edit the reports. |
 |
|
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
Posted - 2009-06-17 : 14:05:15
|
| Thank you for the response, but how do I import the files from the report server to my local machine? I have a report service project started.Duane |
|
|
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
Posted - 2009-06-17 : 14:12:28
|
| I did manage as said above to get the rdl file onto my machine, but they are apparently xml files.Duane |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 14:15:01
|
| you can import the rdl from report server by browsing to report manager, clicking on show details button on top. then click edit button against the report to open properties screen. go to report definition section and click on edit link. it automatically downloads the rdl to machine and asks for where to save. |
|
|
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
Posted - 2009-06-17 : 14:28:05
|
quote:
Originally posted by visakh16
you can import the rdl from report server by browsing to report manager, clicking on show details button on top. then click edit button against the report to open properties screen. go to report definition section and click on edit link. it automatically downloads the rdl to machine and asks for where to save.
This is exactly what I did. Then, I went to Business Intelligence and clicked on File - Open - File, then navigated and got to my downloaded file, discharges.rdl (just for an example), and it opened in Business Intelligence. The tab had the title 'Discharges.rdl [XML]'. This is what was in the tab (first few lines):<?xml version="1.0" encoding="utf-8"?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <DataSources> <DataSource Name="Home Health"> <rd:DataSourceID>3c51156f-c3e8-425a-a065-f6af63df8c9b</rd:DataSourceID> <DataSourceReference>Home Health</DataSourceReference> </DataSource> </DataSources>...etc Thanks for any help here. I don't know what I am missing.Duane |
|
|
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
Posted - 2009-06-17 : 17:14:43
|
| OK - I found the answer on this one, too. Instead of File - Open - File, etc., (what I tried above), right click on Reports in the Solution Explorer, and choose add existing item. Then navigate to your .rdl file and import it that way. I am finding out though, that that doesn't bring in your data source. So, that's my next question.Duane |
|
|
|
|
|
|
|
|
How do I edit existing reports?