Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Documenting RDL files Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 10:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 3:15 PM
Points: 17, Visits: 70
I'm working in SSRS2008 R2 and I have several projects, which in turn have several report definitions held within them.

Each rdl may have many datasets, tablix, matrix definitions detailed within it.

My problem is documentation! I need to document all the datasets, tablix/matrix names, stored procedures etc

Is there an easy way of extracting this information and creating either an excel workbook using VBA, or detailing them back into a SQL2008 table that I can then use SSRS to produce the report?

I have read a similar post that suggests using the reportserver database to get this information from, but if the rdl hasn't been deployed yet it won't be in the database.

Any help would be much appreciated as it will save me going through over 150 rdl's manually and writing down the information.

Thanks




Post #1435029
Posted Monday, March 25, 2013 10:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 3:15 PM
Points: 17, Visits: 70
Sorry folks, I posted this in the wrong Forum.
Post #1435045
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse