When I use the code below I get a grand total. either i need to do some thing besides recomputes or find a way to suppress the grand total that shows up on the last record.
Any Ideas?
thanks in advance Geoff
SET SQUEEZE = ON SET PRINTPLUS = ON DEFINE FILE HOLD_ATT3 SET_AOK/A20=IF HOLD_ATT3.HOLD_ATT.CNT_AOK EQ 0 THEN 'First AOK Required' ELSE IF HOLD_ATT3.HOLD_ATT.CNT_AOK GT 0 THEN 'Other'; END TABLE FILE HOLD_ATT3 -* HERE IS THE MESSAGE PRINT HOLD_ATT3.HOLD_ATT.STVATTR_DESC AS 'AOK' HOLD_ATT3.HOLD_ATT.SHRTRCE_SUBJ_CODE AS 'SUBJ' HOLD_ATT3.HOLD_ATT.SHRTRCE_CRSE_NUMB AS 'NUM' HOLD_ATT3.HOLD_ATT.SHRTRCE_CRSE_TITLE AS 'TITLE' HOLD_ATT3.HOLD_ATT.SHRTRCE_CREDIT_HOURS AS 'HOURS' COMPUTE MSG/A100 = IF HOLD_ATT3.HOLD_ATT.ID EQ LAST HOLD_ATT3.HOLD_ATT.ID AND HOLD_ATT3.HOLD_ATT.SHRTRCE_CREDIT_HOURS GE 30 THEN 'YES this student has 30 or more transfer hours and does not need to take a Liberal Learning Seminar' ELSE 'NO this student has less than 30 transfer hours and will need to take a Liberal Learning Seminar'; NOPRINT BY LOWEST HOLD_ATT3.HOLD_ATT.ID NOPRINT BY HOLD_ATT3.HOLD_ATT.SET_AOK NOPRINT
ON HOLD_ATT3.HOLD_ATT.ID PAGE-BREAK
ON HOLD_ATT3.HOLD_ATT.SET_AOK RECOMPUTE AS 'Total'
ON HOLD_ATT3.HOLD_ATT.ID RECOMPUTE AS 'Total-Articulated'
HEADING "Student name:"Classification:"Evaluator: <+0>Fac. Advisor:<+0> " "Courses Taken Satisfying Areas of Knowledge (AOK): Student has explored the following seven areas" "of knowledge at least one time ( a 3 hour course or a combination of 2 and 1 hour courses) either in" "courses they transferred or in courses they have taken at WSSU" "If the AOK column is empty then the student SHATRNS record does not reflect any articulation with AOK" FOOTING ""the first 30 hours of matriculation" ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE *This message has been edited. Last edited by: Geoff Fish,
