I would like to have a subfoot appear only when it meets a certian criteria? what would an example of this look like?

Ex.
department dairy
subfoot dairy

department HBA/GE
subfoot when HBA
subfoot when GE

department Meat
subfoot meat

department producce
subfoot produce



thanks for the help!

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

hi,

Use a WHEN caluse to have a subfoot when a condition is met:

TABLE FILE CAR
PRINT
RETAIL_COST
BY COUNTRY
ON COUNTRY SUBFOOT
"THIS IS SUBFOOT"
WHEN COUNTRY EQ 'ENGLAND'
ON COUNTRY SUBFOOT
"THIS IS SUBFOOT 2"
WHEN COUNTRY EQ 'W GERMANY'
END


thanks
Sashanka