I have a report which is used in the Layout Component Reference of multiple reports in a server. Is there a way I can find out all the reports containing a reference to the report?
the only way I can think of would be to use a third party tool like metamanager or motio. Find the XML snippet and do a search for that.
An example snippet:
<layoutComponentRef refLayoutElement="Header"><reportPath path="/content/folder[@name='ReferenceLibrary']/report[@name='Sales Components Library']"><XMLAttributes><XMLAttribute xml:space="preserve" output="no" name="ReportName" value="Sales Components Library"/><XMLAttribute xml:space="preserve" output="no" name="ref_iid" value="i3669"/></XMLAttributes></reportPath></layoutComponentRef>
In theory you can export all reports into Export package (ZIP file).
Then Unzip the content of that package .
You should get file like following:
folder data
content.xml
exportRecord.xml
package1.xml
Open file package1.xml in editor (e.g. Notepad++) and look for all strings 'refLayoutElement='
You should be able to figure out how to get Report name from this :-)
If you are dealing with MANY reports (hundreds or thousands) then of course this will not work.
For these cases I am writing XSLT scripts to parse XML ....