Dynamics GP - SQL - SSRS Report List View

This view will display all SSRS objects


CREATE VIEW [dbo].[BI_SSRSList]
AS
SELECT        ReportServer.dbo.Catalog.Name, ReportServer.dbo.Catalog.Path, Catalog_1.Name AS SubName, Catalog_1.Path AS SubPath
FROM            ReportServer.dbo.Catalog INNER JOIN
                         ReportServer.dbo.Catalog AS Catalog_1 ON ReportServer.dbo.Catalog.ParentID = Catalog_1.ItemID

GO