SSRS 2008 Linked Reports Identified From Original Report

[Skittle]

Is there away to look at a report definition in Report manager and list the linked reports that are based on it?

Seems easy to delete an original report thinking it is not used only to find out later that a linked report somewhere else
in the Report Manager structure needs relies on it when a user runs it.

Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.

 

[Skittle]

Update.

Only way I have found to do this is via interrogating the Catolog table in SSMS.

SELECT *
FROM reportserver.dbo.catalog
where LinkSourceID = 
(SELECT ItemID
FROM reportserver.dbo.catalog
where Name = '[I][b]OriginalReportName[/I][/b]')

Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.