This is the same report that was addressed in 2 earlier posts I am down to the last piece having correctly formatted and having verified the correct data. I hope some one can point me in the right direction the problem is getting my second message to show the proper output. It's something simple I am sure but having been working on this for 4 days my brain is kaput. the second message MSG2 should display the number of records that would appear on the first break. I am attempting to count the number of courses trsnferrd that meet certain criteria for admissions to a degree program, ther are 7 and i am attempting to seperate the first instance of each of those 7 from the rest of the data by recomputes at the SET_AOK and recomputes at the ID

Any hints or guidance is appreciated and I will cross posy on higher ed forum

code

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';
AOK_DEF/A30=IF HOLD_ATT3.HOLD_ATT.STVATTR_DESC NE ' ' THEN HOLD_ATT3.HOLD_ATT.STVATTR_DESC ELSE 'Other';
DUMMY/I2=1;
END
TABLE FILE HOLD_ATT3
-* HERE IS THE MESSAGE THE COMPUTE BELOW AND THE WHERE STATEMENT HAVE TO BE REMOVED TO OPEN THE PAINTER
PRINT
HOLD_ATT3.HOLD_ATT.AOK_DEF 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'

DUMMY
COMPUTE AOK_NUM/I2 = IF HOLD_ATT3.HOLD_ATT.ID EQ LAST HOLD_ATT3.HOLD_ATT.ID AND HOLD_ATT3.HOLD_ATT.CNT_AOK EQ 0 THEN DUMMY + 1 ELSE 0;

BY LOWEST HOLD_ATT3.HOLD_ATT.ID NOPRINT
BY HOLD_ATT3.HOLD_ATT.SET_AOK NOPRINT

ON HOLD_ATT3.HOLD_ATT.ID RECOMPUTE AS 'Total-Articulated'
ON HOLD_ATT3.HOLD_ATT.ID RECAP
MSG1/A100 = IF 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';
ON HOLD_ATT3.HOLD_ATT.ID RECAP
MSG2/I2 = AOK_NUM;
ON HOLD_ATT3.HOLD_ATT.ID SUBFOOT
""This student transcript record has ON HOLD_ATT3.HOLD_ATT.ID PAGE-BREAK

ON HOLD_ATT3.HOLD_ATT.SET_AOK RECOMPUTE AS 'Total'
HEADING
"Student name:"Classification:"Evaluator:<+0> <+0>Date:<+0> <+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 hr course or"
"a combination of 2 and 1 hour courses) either in courses articulated or credit recieved by exam or other means"
"If the AOK column is empty then the student SHATRNS record does not reflect any articulations with AOK"

This message has been edited. Last edited by: Geoff Fish,

809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML

SOLVED BY USING SUBOTAL ON SUBFOOT



CNTR/I5= IF HOLD_ATT3.HOLD_ATT.ID EQ LAST HOLD_ATT3.HOLD_ATT.ID AND HOLD_ATT3.HOLD_ATT.CNT_AOK EQ 0 THEN 1 ELSE 0;
DUMMY/I2= 1;
END
TABLE FILE HOLD_ATT3
-* HERE IS THE MESSAGE THE COMPUTE BELOW AND THE WHERE STATEMENT HAVE TO BE REMOVED TO OPEN THE PAINTER
PRINT
HOLD_ATT3.HOLD_ATT.AOK_DEF 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 AOK_NUM/I2 = IF HOLD_ATT3.HOLD_ATT.ID EQ LAST HOLD_ATT3.HOLD_ATT.ID AND HOLD_ATT3.HOLD_ATT.CNT_AOK EQ 0 THEN DUMMY + 1 ELSE 0; NOPRINT


BY LOWEST HOLD_ATT3.HOLD_ATT.ID NOPRINT
BY HOLD_ATT3.HOLD_ATT.SET_AOK NOPRINT

ON HOLD_ATT3.HOLD_ATT.ID RECOMPUTE AS 'Total-Articulated'
ON HOLD_ATT3.HOLD_ATT.ID RECAP
MSG1/A100 = IF 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';
ON HOLD_ATT3.HOLD_ATT.ID SUBFOOT
"'<'MSG1 within the first 30 hours of matriculation"
"This Student Transfer Credit Record fulfills'<'ST.CNTR of the 7 General Education Areas of Knowledge"