SELECT ; cc1.payee_id,; IDNUM,; PAYEETYPE,; NAME1,; ..... BenefitType,; numDeductions,; emplact.shortname AS dedtype,; nvalue,; effdate,; enddate ; FROM cc1; LEFT JOIN emplact ON cc1.payee_id=emplact.payee_id ; AND emplact.shortname IN ("GARNISH","OPMNT"); LEFT join claims ON cc1.BUSSEG_ID = claims.claim_id; LEFT join statute ON claims.statute_ID = statute.statute_id; INTO CURSOR ccPrint; order BY 4,5,2 SET REPORTBEHAVIOR 90 SET RELATION TO payee_id INTO timesht && (payschedule comes from here) SELECT ccPRINT REPORT FORM reports\r_employee_list2 previewthe report has info from ccPRINT in the group and detail bands