SSRS批量查询报表数据源

SELECT

c.Name AS ReportName,

c.Path AS ReportPath,

c.[LinkSourceID],

c2.Name AS DataSourceName,

CASE

WHEN ds.Link IS NULL THEN 'Embedded'

ELSE 'Shared'

END AS DataSourceType

FROM

Catalog c

inner join [DataSource] ds on c.ItemID=ds.ItemID

LEFT JOIN

Catalog c2 ON ds.Link = c2.ItemID -- 关联共享数据源

WHERE

c.Type = 2 -- 2表示报表对象

ORDER BY

c.Path;