SELECT RG2.ShortDescription AS 'Dashboard' , RG2.GroupTypeCode AS 'Type' , CASE WHEN RG1.ShortDescription <> 'New Tab' THEN RG1.ShortDescription END AS 'Sub Tab' , ReportHeader.ReportId AS 'Report Id' , ReportHeader.ReportName AS 'Report' FROM ReportHeader LEFT OUTER JOIN ReportGroupEntity RGE1 ON RGE1.EntityId = ReportHeader.ReportId AND RGE1.EntityTypeCode = 'REPORT' LEFT OUTER JOIN ReportGroup RG1 ON RG1.GroupId = RGE1.GroupId LEFT OUTER JOIN ReportGroupEntity RGE2 ON RGE2.EntityId = RG1.GroupId LEFT OUTER JOIN ReportGroup RG2 ON RG2.GroupId = RGE2.GroupId WHERE ReportHeader.ReportStatusCode = 'OPEN' AND RG1.StatusCode = 'OPEN' AND RG2.StatusCode = 'OPEN'