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
> >>
>