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,

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.

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?

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.

You can do the following. For example, let's say that TOTAID's format is D8.2 and you want to keep the decimals:

  
DEFINE FILE ...
TOTAID/D12.2=TOTAID;
....
END

Thank you, Danny and Ginny.... I'm giving that a try as we speak.

Danny and Ginny,

I wanted to let you know your suggestions worked. Thank you so much for your willingness to help!