I did a dumb thing and managed to clear out a file with a bunch of reports in it. We are having problems pulling the reports from the backup tapes. Is there a way to retrieve the rdl from the report server It is about 12 reports and I would rather not have to recreate them.
Retrieving rdl from Server
Hot Topic
- Is Installing SQL05dev and VS05pro on the same machine supported?
- Inconistent time out error during update operation.
- Filter a Model Table?
- SQL Studio 2005 projects vs. VS.NET database projects. Which is better?
- How to view Cube in WEB Browser(IE) like Pivot tables of Excel
- ISAPI Error
- modify procedure sys.sp_datatype_info
- why doesnt this work?
- Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?
- Datafields in report header
SQL Server
- system.outofmemoryexception
- Rebuilding dimensions with huge fact tables
- Calendar Date Picker in Report very slow to load
- DDS- New Concdern
- When creating, how to specify that Table belongs to a particular schema?
- Complex sql (inefficient multiple column count)
- SSIS Deployment Clarificaiton needed.
- database tuning advisor
- Howto reinstall with local encrypted data, no domain?
- Graph(Chart) showing data
Retrieving rdl from Server
lx
There are many ways to retrieve the RDLs from the report server (assuming you have permissions beyond just "Browser" permissions).
* Manual retrieval:
You can retrieve the RDL for published reports by switching to the details view in report manager (http://localhost/Reports/Pages/Folder.aspx ViewMode=Detail) and then clicking the edit icon next to the report you are interested in. This will bring up the "report properties" page. On the general tab of that page, there is a "Report Definition" section with an "Edit" button. Click on the "Edit" button and you can retrieve the RDL file from the ReportServer.
* Management Studio:
With the SQL Server 2005 Management Studio you can connect to the report server and manage your reports (including retrieving RDLs).
* SOAP API:
You can use the SSRS SOAP API to retrieve report definitions. Use the GetReportDefinition method: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_2eew.asp
* RS Scripter tool:
Download Jasper Smith's RS Scripter tool: http://www.sqldbatips.com/showarticle.asp ID=62
-- Robert
regthesk8r