smartinson avatar image
smartinson asked

Finding linked reports in SSRS Report Manager 20005

I am migrating from SSRS 2005 to SSRS 2008. Is there a way that I can query the data from some of the tables in the ReportServer database (or elsewhere) to find out which reports in the Report Manager are linked to which reports? This query returns linked reports - SELECT Type, ItemID, Path, Name, ParentID, LinkSourceID, Description, ModifiedDate FROM Catalog WHERE (Type = 4) but how do I find the reports the linked reports are linked to? Are the ItemID, ParentID and LinkSourceID fields static or do they change whenever reports are run making this approach totally unusable? Thanks in advance.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers