I've got an ON TABLE SUBFOOT section in a FOCEXEC that is giving me nothing but asterisks on my various totals lines.... I can't see actual amounts. I don't know what I'm doing wrong! Here's my subfoot snippet, if anyone wants a quick look:
TABLE FILE S081C&INSTX
-*
HEADING CENTER
-*
"<1 PROGRAM ID: &PRG <58 PAGE <TABPAGENO"
"<50 &DATE &TOD"
"NEED BASED SCHOLARSHIPS AWARD YEAR: &AWDYR <COLLEGE"
" "
-*
SUM
-*
STDCNT NOPRINT
TOT.BUDGET NOPRINT
TOT.TFC NOPRINT
TOT.TOTAID NOPRINT
TOT.TOTUNMET NOPRINT
-*
PRINT
-*
RAP AS 'R,A,P'
BUDGET AS 'BUDGET'
TFC AS 'TOTAL,FC,(EFC)'
TOTAID AS 'TOTAL, AID'
TOTUNMET AS 'TOTAL,UNMET,NEED'
-*
BY COLLEGE NOPRINT REPAGE
BY SNAME/C AS 'NAME' NOSPLIT IN 0
BY STU_ID/C AS 'SSN'
-*
WHERE TOTAID GT 1.00
-*
ON TABLE SUBFOOT
-*
" "
"============================================================"
"------------------------------------------------------------"
"TOTAL STUDENTS : <TOT.STDCNT "
"TOTAL BUDGET AMOUNT: <TOT.BUDGET "
"TOTAL FINANCIAL AID: <TOT.TOTAID "
"TOTAL UNMET NEED : <TOT.TOTUNMET "
"TOTAL AVERAGE AWARD: <AVE.TOTAID "
"------------------------------------------------------------"
"============================================================"
-*
ON TABLE SET SPACES 1
-INCLUDE REPTDEL7
-*
END
-RUN
-INCLUDE RETYPE
-TYPE Run Successfully Completed
-*
Thank you in advance.... looking forward to seeing what I might be doing wrong.This message has been edited. Last edited by: webmeister,
Mainframe FOCUS 7.0 VM/CMS and MVS/TSO
May 22, 2008, 09:37 AM
Danny-SRL
webmeister, Take off your NOPRINTs and see if you also get asterisks within the report. If you do, that means that the total field is too big for the format.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
May 22, 2008, 10:07 AM
webmeister
Thanks, Danny,
I'll give that a try. Question: If my total fields are too big for the format, how do I resolve that so I get good output?
Mainframe FOCUS 7.0 VM/CMS and MVS/TSO
May 22, 2008, 10:18 AM
GinnyJakes
Increase the size of the field you are summing. The size of the total field is the same size as the summed field. If the answer is too big, you will get the asterisks. So make the summed field bigger.