Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Every man's memory is his private literature
 
Huxley
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

14
November

How Do I Generate an SQL Server Reporting Services Report List

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

MAKE A COMMENT

Name *

Email Address *

Comment *