asked
find linked reports in Report Manager 2005
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.
@martinson, the ItemIDs etc are fixed and do not change over time. You can join your select back to the dbo.Catalog on LinkSourceID = ItemID to locate the report to which the current report is linked. Anyway, there is no official info from microsoft about the SSRS database schema and this schema can be changed without any notice. But the main schema was not changed from SQL2005 til 2008R2. **Edit:** The only officialy supported way of working with the SSRS is the Web Service SOAP API. Eg. For the Linked reports the reference is [here][1] and complete Web Service described [here][2]. [1]:
http://msdn.microsoft.com/en-us/library/ms152864.aspx [2]:
http://msdn.microsoft.com/en-us/library/ms152787.aspx
Thanks, I was trying to join on the wrong fields. This query worked for me - 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
Yeah. :-) if it solved the problem, then also accept the answer, so the question isn't left unanswered. :-)
