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 |
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
 Posted - 2009-09-15 : 10:09:31
|
| I am trying to locate where on our report server our .RDL get deployed to. I did not do the original install so I am not sure where to go. Are the reports and data sources store as files and folders like "normal" windows files or are they stored within a SQL database?John"The smoke monster is just the Others doing barbecue" |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-17 : 14:35:10
|
| An update on what I have found out if others have the same question.- There is no RDL on the Report Server or within the SQL database where the information is stored. The definition components are stored in various tables though.- To get a list of reports within your environment:SELECT Catalog.PathFROM ReportServer.dbo.Catalog CatalogWHERE (Catalog.Type=2)ORDER BY Catalog.PathTo retrieve the RDL if missing or you don't have access to your code repository:Open Report Manager. Navigate to report you want RDL for. Click Properties to edit. Click Edit under Report Definition and Report Manager prompts you to save or open.John"The smoke monster is just the Others doing barbecue" |
 |
|
|
|
|
|
Where does server store .RDL?