I have read all the posts to get subtotal on one line and all the tricks with blank/a1=' ', etc. My users just want one total for the whole report (no subtotals). They want the output in exl2k. I have tried all the tricks I read about and none of them seem to work with a grand total only. If I put a subtotal in the report, then the tricks work. I've tried doing some things in the stylesheet and using on table subfoot, but I can't seem to position my amount column under the correct column in exl2k. It ignores my positioning. Here is sample code with the car file which I'm coloring to show the field, but all the stylesheet options I've tried haven't worked. Any suggestions?

TABLE FILE CAR
PRINT
COUNTRY
BODYTYPE
SALES
ON TABLE SUBFOOT
"TOTAL<+0> WHERE READLIMIT EQ 100
WHERE RECORDLIMIT EQ 100
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABFOOTING,
ITEM=3,
COLOR='RED',
JUSTIFY=RIGHT,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
JUSTIFY=CENTER,
$
ENDSTYLE
END

Have you tried this

ON TABLE SUBTOTAL