Hi, I have a client with many folders/ reports who would like a list of their reports inclusive of the folder hierarchy. Can anyone please suggest a way to achieve this using DEPM 11?
Hi Leanne,
i've not seen any way to get this from Application Studio itself, however you can create a relational report (SQL extract) from your reporting repository - this is a 'sample' of the script you can create and use in an application studio report (hide the details / information you dont want)
coReport table contains the report / report makeup information (its in xml / blobs
coFolder table lists all of the folders in the app studio repository
coReportType table gives you a list of the different report types (in my example below i am only pulling the on-vision reports)
--report list ordered into 'folders'
SELECT rep.IDFolder, fol.name, rep.IDReport,rep.Name,rep.Description,rep.IDString,rep.IDReportType,rep.ChildOrder,rep.UCParentID,rep.IDReportTemplate
FROM [dbo].[coReport] rep JOIN [dbo].[coFolder] fol on fol.idfolder = rep.IDfolder where IDReportType = 'C737993A-CB9F-4050-97AB-0B3CFA01357E' order by fol.name
--LIST all folder types
SELECT [IDFolder],[IDParentFolder],[Name],[Description] FROM [dbo].[coFolder]
--LIST all Report Types
SELECT [IDReportType],[Name],[Description] FROM [dbo].[coReportType]
Hopefully someone with better SQL skills can improve this for us
Peter Chapman
Consultant
+6628382485
