question

smartinson avatar image
smartinson 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.
sql-server-2005ssrsmigration
10 |1200 characters needed characters left characters exceeded

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

1 Answer

· Write an Answer
Pavel Pawlowski avatar image
Pavel Pawlowski answered
@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
2 comments
10 |1200 characters needed characters left characters exceeded

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

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
0 Likes 0 ·
Yeah. :-) if it solved the problem, then also accept the answer, so the question isn't left unanswered. :-)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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