SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How can I document reports (RDL) files?


How can I document reports (RDL) files?

Author
Message
Jitendra Luniya
Jitendra Luniya
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 90
Hi,

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

Regards - JL
Niraj-627298
Niraj-627298
SSC-Addicted
SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)

Group: General Forum Members
Points: 495 Visits: 719
Hi...Smile

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
Pvm_25
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 957
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
Daveee
Right there with Babe
Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)

Group: General Forum Members
Points: 750 Visits: 1033
Have you thought of querying the ReportServer database?

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

D
Pvm_25
Pvm_25
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 957
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
Daveee
Right there with Babe
Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)Right there with Babe (750 reputation)

Group: General Forum Members
Points: 750 Visits: 1033
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
Pvm_25
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 957
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
agrawal.prakriti
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 101
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
Pvm_25
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 957
Not exactly...I need the information from rdl file ...execution log gives inforamtion about report executions....thanks for the reply though...:-)
becklery
becklery
SSC Veteran
SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)

Group: General Forum Members
Points: 293 Visits: 187
Here are the steps:

1. Go to Report on Report Manager

2. Click "Show Details"

3. Click "Properties" of the report you need to Export

4. Under "Report Definition", click on "Edit".

You will be able to either "Open" or "Save" the RDL file.

RAQ Report: Web-based Excel-like Java reporting tool
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search