how do you find linked reports from Main report in SSRS
-
Wednesday, August 01, 2012 3:13 PM
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
- Edited by Mbia_10 Wednesday, August 01, 2012 3:14 PM
All Replies
-
Wednesday, August 01, 2012 8:57 PM
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- Proposed As Answer by Iric WenModerator Sunday, August 05, 2012 11:06 AM
- Marked As Answer by Iric WenModerator Thursday, August 09, 2012 2:06 AM

