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.