On starting a new SSRS report writing project, the first thing I needed to do was to audit the current reports, on the server.
Solution:
The quickest why to generate this list was to write a quick SQL script:
Select [Name], [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]
where [Type] = 2
Order by SUBSTRING ([Path],1 , Len ([Path])- (charindex('/', Reverse ([Path]))-1)), [Name]
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us |