where is the report rdl name stored in the database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJ Wang - 26 Aug 2008 02:43 GMT

hi,

In the 'report server' database, which table/column contains the report
'.rdl' file names? is it in the catalog table? I'm currently working on sql
2005 and 2008 SSRS.

thanks!

JJ

Reply to this Message

Bruce L-C [MVP] - 26 Aug 2008 13:54 GMT

You got me curious so I explored a little:
select path,name, type, description from catalog order by type,name

Type evaluates to (based on my observation, not any documentation)

1: folder

2: report

3: Non-rdl (I have some html and .doc files uploaded to Reporting Services.
Those have a type of 3 when I query the catalog table.)

4: linked report

5: data source

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> hi,
>
[quoted text clipped - 6 lines]
>
> JJ

Reply to this Message

JJ Wang - 27 Aug 2008 03:29 GMT

thanks Bruce. This is really helpful. So are you saying that 'name' column
is the physical rdl file's file name for type 2 (report)?

Do you also know anyway from the website that can generate report (or gather
data) for each report's rdl file name and file upload path?...

I've been searching for books online to explain each column in these tables,
couldn't find any link. shouldn't be this hard to find, one would think. :-)

JJ

> You got me curious so I explored a little:
> select path,name, type, description from catalog order by type,name
[quoted text clipped - 22 lines]
> >
> > JJ

Reply to this Message

Bruce L-C [MVP] - 27 Aug 2008 14:39 GMT

As far as I know this is undocumented and could change from version to
version. One supported way to find out this information is looking at web
services. There is a whole lot of functionality available via web services.
I haven't used them so I am not familiar with it. Also, check out URL
access. I know you can list out reports using a URL (and anything done via a
URL can be done by web services as well). URL access and web services are
the supported way of doing things. Querying the tables directly like I
showed you is not supported and hence can change at any time.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> thanks Bruce. This is really helpful. So are you saying that 'name'
> column
[quoted text clipped - 39 lines]
>> >
>> > JJ

Reply to this Message

JJ Wang - 27 Aug 2008 18:38 GMT

thank you so much Bruce, you've been so helpful! It's a shame that not so
much good documentations from Microsoft around SSRS. I guess we will have to
experiment and find out ourselves. :-)

Hope will see more good documentation from MS about SSRS soon.

take care,

JJ

> As far as I know this is undocumented and could change from version to
> version. One supported way to find out this information is looking at web
[quoted text clipped - 48 lines]
> >> >
> >> > JJ

Reply to this Message

Bruce L-C [MVP] - 27 Aug 2008 18:52 GMT

There is a lot of documentation around the URL integration and web services.
Think of it this way. Anything you see Report Manager doing you can do with
Web Services. Indeed, Web Services is how Report Manager (which is just an
asp.net application) does everything.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> thank you so much Bruce, you've been so helpful! It's a shame that not so
> much good documentations from Microsoft around SSRS. I guess we will have
[quoted text clipped - 64 lines]
>> >> >
>> >> > JJ

Reply to this Message

JJ Wang - 27 Aug 2008 19:06 GMT

thanks Bruce, I will be sure to check it out! :-)

JJ

> There is a lot of documentation around the URL integration and web services.
> Think of it this way. Anything you see Report Manager doing you can do with
[quoted text clipped - 69 lines]
> >> >> >
> >> >> > JJ

Reply to this Message