Say I have something along the lines of :
TABLE FILE CAR
SUM RETAIL_COST AS 'TITLE1' LENGTH AS 'TITLE2' OVER DEALER_COST AS '' WIDTH AS ''
BY CAR
END

Which outputs:
ALFA ROMEO TITLE1 19565 TITLE2 510
xxxxxxxxxxx 16235 188

Is there a way I can get it to display like:
ALFA ROMEO TITLE1 TITLE2
xxxxxxxxxxx 19565 510
xxxxxxxxxxx 16235 188

(The x's are spaces)

Eric

.eric,

Here's an idea, there may be others:

DEFINE FILE CAR
DUMMY/A1 = ' ';
END
TABLE FILE CAR
SUM
RETAIL_COST AS ''
LENGTH AS '' OVER
DEALER_COST AS ''
WIDTH AS ''
BY DUMMY NOPRINT
BY CAR AS ''
ON DUMMY SUBHEAD
"Car <+0> Title1 <+0> Title2"
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
SQUEEZE=ON,
GRID=ON, WRAP=ON,
FONT='ARIAL',
SIZE=9,
STYLE=BOLD,
JUSTIFY=CENTER,
$
-********************************************************************
-* Align the headings
-********************************************************************
TYPE=SUBHEAD,
BACKCOLOR=RGB(176 196 222),
HEADALIGN=BODY,
$
END

-EXIT

A slight modification to Tom's code gives exactly what you wanted -

DEFINE FILE CAR
DUMMY/A1 = ' ';
END
TABLE FILE CAR
SUM DUMMY       AS ''
    RETAIL_COST AS '' 
    LENGTH      AS '' OVER 
    DUMMY       AS ''
    DEALER_COST AS '' 
    WIDTH       AS ''
 BY CAR         AS '' NOPRINT
ON CAR SUBHEAD
"<CAR Title1 <+0> Title2"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $
TYPE=REPORT, GRID=OFF, WRAP=ON, FONT='ARIAL', SIZE=9, STYLE=BOLD, $
TYPE=TITLE, JUSTIFY=CENTER, $
-* Align the headings
TYPE=SUBHEAD, BACKCOLOR=RGB(176 196 222), HEADALIGN=BODY, $
ENDSTYLE
END

T

Looks good, thanks guys!

Eric

Is there a way to get this to work in PDF format?

Eric

SET PRINTPLUS=ON
Take out the word WRAP.