Retrieving the RDL from SQL Server

I just came across a query by the same name as this one, but I have a
slightly different purpose in mind. I have an application which builds
filterable and hideable columns on the fly, but it currently requires a
copy of the RDL to be kept outside of the Report Server, some place
accessible. Obviously, this makes things more difficult, since it means
that the external reports always have to match the uploaded reports. Is
there any way to extract the RDL from the report server so that these
columns can be built on the fly?
Thank you,
NoahIn your ReportServer database. Table Catalog and Content Field.
Thanks
Jerry
http://www.rdlcomponents.com
"Noah" wrote:
> I just came across a query by the same name as this one, but I have a
> slightly different purpose in mind. I have an application which builds
> filterable and hideable columns on the fly, but it currently requires a
> copy of the RDL to be kept outside of the Report Server, some place
> accessible. Obviously, this makes things more difficult, since it means
> that the external reports always have to match the uploaded reports. Is
> there any way to extract the RDL from the report server so that these
> columns can be built on the fly?
> Thank you,
> Noah
>|||Thanks.
Is there any easy way to read that data? It's in the database as an
image, so I cannot read the XML. Can I access it through the web service?
Thanks,
Noah
Jerry wrote:
> In your ReportServer database. Table Catalog and Content Field.
> Thanks
> Jerry
> http://www.rdlcomponents.com
> "Noah" wrote:
>
>>I just came across a query by the same name as this one, but I have a
>>slightly different purpose in mind. I have an application which builds
>>filterable and hideable columns on the fly, but it currently requires a
>>copy of the RDL to be kept outside of the Report Server, some place
>>accessible. Obviously, this makes things more difficult, since it means
>>that the external reports always have to match the uploaded reports. Is
>>there any way to extract the RDL from the report server so that these
>>columns can be built on the fly?
>>Thank you,
>>Noah|||You have to read that data as Byte[] and the convert to string, something like:
System.Text.Encoding enc = System.Text.Encoding.ASCII;
string myRDL = enc.GetString(myByteArray );
Thanks
Jerry
http://www.rdlcomponents.com
"Noah" wrote:
> Thanks.
> Is there any easy way to read that data? It's in the database as an
> image, so I cannot read the XML. Can I access it through the web service?
> Thanks,
> Noah
> Jerry wrote:
> > In your ReportServer database. Table Catalog and Content Field.
> >
> > Thanks
> > Jerry
> > http://www.rdlcomponents.com
> >
> > "Noah" wrote:
> >
> >
> >>I just came across a query by the same name as this one, but I have a
> >>slightly different purpose in mind. I have an application which builds
> >>filterable and hideable columns on the fly, but it currently requires a
> >>copy of the RDL to be kept outside of the Report Server, some place
> >>accessible. Obviously, this makes things more difficult, since it means
> >>that the external reports always have to match the uploaded reports. Is
> >>there any way to extract the RDL from the report server so that these
> >>columns can be built on the fly?
> >>
> >>Thank you,
> >>
> >>Noah
> >>
>

Retrieving the RDL from SQL Server

I have lost the reports that I designed. They were deployed and are currently
being used.
Is there a way to get the RDL out of the ReportServer database ?
Thanks,
Craigon the Properties tab of the report you are interested in (click show details
on report manager menu), click Edit, this will let you download the rdl of
the report to wherever you wish.
"Craig HB" wrote:
> I have lost the reports that I designed. They were deployed and are currently
> being used.
> Is there a way to get the RDL out of the ReportServer database ?
> Thanks,
> Craig
>
>

Retrieving rdl from Server

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.

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

|||I should have mentioned that I am running RS2000 sorry. The Scripting tool was extrememely helpful though.sql

Retrieve the .rdl file from the reporting services server

Is it possible to retrieve the ".rdl" file published on the Reporting Services
server...
I made a stupid mistake and renamed a report from let say a.rdl to b.rdl
and started to revise the report. Then later on I needed to do some changes
to the published report a.rdl... Though, this file (a.rdl) doesn't exist on
my computer anymore...
Thanks in advance for any tipsHi Andreas:
I'd write an .RSS script file to pull the rdl with the web service.
Look in the books online at the GetReportDefinition method, it even
includes a sample to save the file to disk.
--
Scott
http://www.OdeToCode.com/blogs/scott
On 14 Oct 2004 09:24:17 -0700, akardell@.home.se (Andreas Kardell)
wrote:
>Is it possible to retrieve the ".rdl" file published on the Reporting Services
>server...
>I made a stupid mistake and renamed a report from let say a.rdl to b.rdl
>and started to revise the report. Then later on I needed to do some changes
>to the published report a.rdl... Though, this file (a.rdl) doesn't exist on
>my computer anymore...
>Thanks in advance for any tips|||Wherever the report is deployed, click on the report properties and then
click on the report, the properties tab, the edit link. You will be asked
where you want to save the rdl. Once you have saved the rdl then just add it
back to your project.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andreas Kardell" <akardell@.home.se> wrote in message
news:67424f9d.0410140824.27a8add8@.posting.google.com...
> Is it possible to retrieve the ".rdl" file published on the Reporting
Services
> server...
> I made a stupid mistake and renamed a report from let say a.rdl to b.rdl
> and started to revise the report. Then later on I needed to do some
changes
> to the published report a.rdl... Though, this file (a.rdl) doesn't exist
on
> my computer anymore...
> Thanks in advance for any tips|||Haha! Yep, I've been doing so much WS stuff lately it seems like it is
always the first solution that springs to mind. Thanks for pointing
that one out, Bruce.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Thu, 14 Oct 2004 14:19:19 -0500, "Bruce L-C [MVP]"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>Wherever the report is deployed, click on the report properties and then
>click on the report, the properties tab, the edit link. You will be asked
>where you want to save the rdl. Once you have saved the rdl then just add it
>back to your project.|||Thank you Bruce and Scott!
That saved me a lot of trouble! And really simple solution too... those are
the best ones!
//Andreas
Scott Allen <bitmask@.[nospam].fred.net> wrote in message news:<8ueum0lit3nhpv83bs1jkajg4p1pmfj38s@.4ax.com>...
> Haha! Yep, I've been doing so much WS stuff lately it seems like it is
> always the first solution that springs to mind. Thanks for pointing
> that one out, Bruce.
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Thu, 14 Oct 2004 14:19:19 -0500, "Bruce L-C [MVP]"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
> >Wherever the report is deployed, click on the report properties and then
> >click on the report, the properties tab, the edit link. You will be asked
> >where you want to save the rdl. Once you have saved the rdl then just add it
> >back to your project.