how do you find linked reports from Main report in SSRS

Question

 I need to know if there is a way to find the related linked reports from an existing Main (Parent)  SSRS Report.  When i open the Main SSRS report  and click on Manage i thought it would give me a list of all the related linked reports under that Main report but it does not.

Any advice or help would be great.

 thanks

Answer 1

From: http://ask.sqlservercentral.com/questions/29955/find-linked-reports-in-report-manager-2005.html

SELECT 
    c1.Name AS LinkedReport, c1.Path AS LinkedReportLocation,
    c2.name AS OrginalReport,c2.Path AS OrginalReportPath 
FROM dbo.Catalog c1 INNER JOIN dbo.Catalog AS c2 
    ON c1.LinkSourceID=c2.ItemID

This seems to give you the information that you want, although perhaps not in the format you want.   But now that you can query the data you should be able to answer your question.

FWIW,
RLF