Description
To check RTR creation for specific Program ID
Query :
To check RTR creation for specific Program ID
Query :
SELECT DISTINCT PCR.ReportShortName, PCSR.ProgramItemsIds,PCR.ProgramIds
FROM ProgramCustomReportSetup PCR
JOIN ProgramCustomSubReport PCSR ON PCR.ProgramCustomReportSetupId = PCSR.ProgramCustomReportSetupId
WHERE PCR.ProgramIds IN ('7435','7857')
order by PCR.ProgramIds asc
--------------------------------------------------