I am summing up a few different columns using the on field recap. I put these recap fields in the subfoot of the report. These fields are printing in the subfoot but also in the body. How can i get the fields to only print in the subfoot and not in the body of the report. Below is the code I used. Any help would be greatly appreciated!!


ON RPT_BCKT RECAP
ADHY_PCT/D14.2C = DHY_DTL_PCT;
ABCHY_PCT/D14.2C = BCHY_DTL_PCT;
ADHY/D14.2C = DHY_TOT;
ABCHY/D14.2C = BCHY_TOT;

ON RPT_BCKT SUBFOOT
"<ADHY_PCT> <ABCHY_PCT> <ADHY> <ABCHY>"

Then I place it in the report

TYPE=SUBFOOT, OBJECT=FIELD, LINE=2, ITEM=1, JUSTIFY = RIGHT, POSITION=DHY_PCT, STYLE=BOLD, COLOR=NAVY,$

By using NOPRINT against those in the body of the report.

Tony,

In the body I calculated these compute fields

COMPUTE DHY_DTL_PCT/D14.2C = IF PARNT EQ 'N' THEN DHY_PCT ELSE 0; NOPRINT
COMPUTE BCHY_DTL_PCT/D14.2C = IF PARNT EQ 'N' THEN BCHY_PCT ELSE 0; NOPRINT
COMPUTE DHY_TOT/D14.2C = IF PARNT EQ 'N' THEN DHY ELSE 0; NOPRINT
COMPUTE BCHY_TOT/D14.2C = IF PARNT EQ 'N' THEN BCHY ELSE 0; NOPRINT

I am assuming the compute fields the values getting printed in the body and I do have NOPRINTS

any suggestions

This message has been edited. Last edited by: jbanas6,