Report Cards / Profiles
// No records were returned. Print Where header and move on.
No records returned SELECT FILE_GROUP, REPORT_NUMBER, REPORT_DESC, MIN_LEVEL, FILE_LOC, FILE_NAME, FILE_EXT, SLN_BASED, HAS_LEADING_ZERO, TO_CHAR(FILE_DATE, 'MM/DD/YY') AS FILE_DATE, FILE_DATE AS FILE_DATE_SORT, TO_CHAR(FILE_DATE, 'YYYY') AS FILE_YEAR FROM tbl_REPORT_SECURITY WHERE VALID_FLAG = 1 and (ACCESS_LEVEL = '0' AND MIN_LEVEL <= 0) AND FILE_GROUP='Report Cards/Profiles' AND SLN_BASED = 0 ORDER BY FILE_GROUP, FILE_DATE_SORT DESC, REPORT_DESC, REPORT_NUMBER