Hello everybody,

I don't want the subfoot to be printed if the result of SUM CNT.DST.TSC_CODINT is 1.
How can I code it ?
Thanks for help.


here is my code
TABLE FILE TMP_STATS_CA
SUM
CNT.DST.TSC_CODINT WITHIN TCA_LIB NOPRINT AS 'NbMes'
NB AS 'Nb'
MONTANT AS 'Montant'
BY MOIS NOPRINT
BY LIBMOIS NOPRINT
BY SVDAVE AS 'Date'
BY TCA_CODE AS 'Opération'
BY TCA_LIB AS 'Libellé'
BY TSC_CODINT AS 'Message'
BY TSC_LIB AS 'Libellé'

ON LIBMOIS SUBHEAD
"
ON TCA_LIB SUBFOOT
"

I don't see a subfoot in your code, but

ON LIBMOIS SUBFOOT MULTILINES ... don't have a sample in front of me so check spelling and order

Cati,
Please resend your procedure but put it between the CODE and /CODE tags. you can find them in the last icon on the message bar. The we can see your subfoot.
A bientot,

MULTILINES works perfectly.
Thanks a lot for your answer.
Catherine.

You're welcome, Cati, Welcome to the world of Focal Point.