Tag Archives: ssrs catalog report list

SSRS Report List for your Report Catalog

Obtain a list of reports in your  SQL Server Reporting Services Catalog with this nice query, which you can plug straight into a Reporting Services report.


SELECT Catalog.*

FROM

(

Select   [Name],

CASE

WHEN Type = 1 THEN 'Folder'

WHEN Type = 2 THEN 'Report'

WHEN Type = 3 THEN 'File'

WHEN Type = 5 THEN 'Data Source'

WHEN Type = 9 THEN 'Report Part'

ELSE 'Other' END AS ContentType,

CASE WHEN SubType IS NULL THEN 'N/A'

ELSE SubType END AS 'Report Part Type',

[Description],

SubString([Path],1,Len([Path]) - (CharIndex('/',Reverse([Path]))-1))
) As [Path],

Case

When [Hidden] = 1

Then  'Yes'

Else    'No'

End As [Hidden]

From    [Catalog]

)

Catalog

Order By Path, Name

Thanks to Nathon Dalton for this blog

http://nathondalton.wordpress.com/2010/02/22/get-reporting-services-report-list-from-database/