Hello,
I have request to display one row value on the PO_NAME subfoot. I appreciate any one have suggestion....

ON PO_NAME SUBFOOT
One Row Value..... 15,738,628 15,072,328 15,072,421 10,733,680

This message has been edited. Last edited by: FP Mod Chuck,

You need to be more detailed v_ani.

Where does these subfoot "values" come from ? Static values, values from the file used to produce de report ?

Have you search in the doc ? Have you used AppStudio to built your subfoot ?

Martiny,
PLEASE SEE THE CAR EXAMPLE I WANT THE FRANCE ROW 2 LINE OF THE OUTPUT TO SHOW AS LAST ROW INSTEAD OF 2ND ROW.
TABLE FILE CAR
SUM
COUNTRY
CAR
MODEL
BY COUNTRY NOPRINT
END
-***********************
the output
COUNTRY CAR MODEL
ENGLAND TRIUMPH TR7
FRANCE PEUGEOT 504 4 DOOR
ITALY MASERATI DORA 2 DOOR
JAPAN TOYOTA COROLLA 4 DOOR DIX AUTO
W GERMANY BMW 530I 4 DOOR AUTO

Hi v_ani,

Please use code tag when including code sample or result sample. It's the last icon on the ribbon

</>

Without understanding your goal, the simplest solution is the following:

DEFINE FILE CAR
ROWID /I2 = IF COUNTRY EQ 'FRANCE' THEN 99 ELSE 1;
END
TABLE FILE CAR
SUM
COUNTRY
CAR
MODEL
BY ROWID   NOPRINT
BY COUNTRY NOPRINT
END