How can I document reports (RDL) files?

Question

Post reply

How can I document reports (RDL) files?

Jitendra Luniya

SSC Eights!

Points: 981
More actions
January 27, 2009 at 12:42 am

#199246

Hi,
Is there any way to document RDL files to get information like Report name, data source, parameters and other information?
Regards - JL

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Niraj-627298 Hall of Fame Points: 3641 More actions · Answer 1

Hi...:)

I think...you can retreive information frm an RDL file using Reporting Service Web Service and concerned methods....

Please try creating an object for the same and access the desired information...u need...

Thanks,

Niraj

Pvm_25 Ten Centuries Points: 1073 More actions · Answer 2

Hey Jitendra...did you find anything regarding documenting rdl files?....I am also looking for the same....if you've got ur answer please share it.....it will be really helpful....thanks

Daveee SSCommitted Points: 1600 More actions · Answer 3

Have you thought of querying the ReportServer database?

look in dbo.Catalog & dbo.DataSource for the info you need.

D

Pvm_25 Ten Centuries Points: 1073 More actions · Answer 4

Actually reportserver wont give me all the information I need. I want the report description, parameters used in that, drill through links etc....and all of this informations I have to dig from rdl file itself.

Daveee SSCommitted Points: 1600 More actions · Answer 5

I can find the description of all my reports in SSRS 2005 via dbo.Catalog.Description

Params can be extracted from the parameters column.

Another option is an SSIS package or some powershell to find other attributes by looking through rds files.

Pvm_25 Ten Centuries Points: 1073 More actions · Answer 6

Yes , you are right about catalog table....I can use that for name, description, parameters.....but my requirements for documenting rdl also needs drill thtough links, datasource, dataset fields ......

I have tried building SSIS package but rdl files has some namespace problem, so I was not able to use XML source using plain xml from rdl files and xml schema provided by microsoft.....It returned me errors saying namespace issue....

So now I am trying to write Xquery that returns me elements and attributes i need so i can store them in database and use that. But the problem i m facing is to get the specific level for the elements in the huge rdl file. for ex. I have 4 drill through link in one report, all are in different data regions so the element level is different for each of them. :crazy: ...and I am also new with xquery...

Powershell is totaly new thing for me.....so if you can point me to some good sites/articles that explains either powershell to do this kind of stuff or ssis package or xquery....anything will work for me to get this done....thanks in advance...

agrawal.prakriti Mr or Mrs. 500 Points: 572 More actions · Answer 7

not sure if you are asking the same thing. Report server maintains a server log and it can be queried

http://msdn.microsoft.com/en-us/library/ms159110.aspx

Pvm_25 Ten Centuries Points: 1073 More actions · Answer 8

Not exactly...I need the information from rdl file ...execution log gives inforamtion about report executions....thanks for the reply though...:-)

becklery Hall of Fame Points: 3315 More actions · Answer 9