Hi ,
I need multiple columns as rows in a single column. I need the multiple COLUMNS as ROWS in a single Column as shown below.

Example: for CAR FILE

CAR DEALER_COST
COUNTRY RETAIL-COST
MODEL
--------------------------------------
TOYOTA 25,000
JAPAN 30,000
1999

ON MODEL SUB-TOTAL AS :$$$$$$$$

Regards,
MSAM

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

here is the correct display
CAR DEALER_COST
COUNTRY RETAIL-COST
MODEL
--------------------------------------
TOYOTA 25,000
JAPAN 30,000
1999

Here is one possibility:

DEFINE FILE CAR
 BLANK/A1 = ' ';
END
-*
TABLE FILE CAR
 PRINT CAR AS ''
       DEALER_COST AS ''
  OVER COUNTRY AS ''
       RETAIL_COST AS ''
  OVER MODEL AS ''
  OVER BLANK AS ''
 ON TABLE SUBHEAD
  "CAR DEALER_COST"
  "COUNTRY RETAIL-COST"
  "MODEL"
END

The "correct display" doesn't look any different than the incorrect display!!! Put the program code and expected results between

[CODE]

[/CODE]

tags.

Example:

TABLE FILE CAR
SUM
CAR AS '' DEALER_COST AS '' OVER
COUNTRY AS '' RETAIL_COST AS '' OVER
MODEL AS '' 
BY CAR NOPRINT
BY COUNTRY NOPRINT
BY MODEL NOPRINT

ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON,
FONT=ARIAL, SIZE=8,
$
ENDSTYLE
END

Results:

ALFA ROMEO              4,915
ITALY                   5,925
2000 4 DOOR BERLINA
ALFA ROMEO              5,660
ITALY                   6,820
2000 GT VELOCE
ALFA ROMEO              5,660
ITALY                   6,820
2000 SPIDER VELOCE
AUDI                    5,063
W GERMANY               5,970
100 LS 2 DOOR AUTO
...

Hi Francis,
Thanks for the update. In this case how would I display the Titles for the columns.

Regards,
MSAM

Dan shows you one way to include the column titles. You can use styling to align the text:

TABLE FILE CAR
SUM
CAR AS '' DEALER_COST AS '' 
OVER
COUNTRY AS '' RETAIL_COST AS '' 
OVER
MODEL AS ''
COMPUTE BLANK1/A1=' '; AS '' 
OVER 
COMPUTE BLANK2/A1=' '; AS ''
COMPUTE BLANK3/A1=' '; AS ''
BY CAR NOPRINT
BY COUNTRY NOPRINT
BY MODEL NOPRINT

HEADING
"TEST REPORT 1"
"CAR <+0> DEALER COST"
"COUNTRY <+0> RETAIL COST"
"MODEL <+0> "

ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON,
FONT='ARIAL', SIZE=8,
$
TYPE=HEADING, HEADALIGN=BODY, $
TYPE=HEADING, LINE=1, COLSPAN=2, $
ENDSTYLE
END

Hi Francis,
That resolves most of my questions. But is where a way to show only the cloumn GRID and not the row GRID when we set the GRID=OFF option

below code give me no GRID since I set it to OFF


TABLE FILE CAR
SUM
CAR AS '' DEALER_COST AS ''
OVER
COUNTRY AS '' RETAIL_COST AS ''
OVER
MODEL AS ''
COMPUTE BLANK1/A1=' '; AS ''
OVER
COMPUTE BLANK2/A1=' '; AS ''
COMPUTE BLANK3/A1=' '; AS ''
BY CAR NOPRINT
BY COUNTRY NOPRINT
BY MODEL NOPRINT

HEADING
"TEST REPORT 1"
"CAR <+0> DEALER COST"
"COUNTRY <+0> RETAIL COST"
"MODEL <+0> "

ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON,
FONT='ARIAL', SIZE=8,GRID=OFF,
$
TYPE=HEADING, HEADALIGN=BODY,$
TYPE=HEADING, LINE=1, COLSPAN=2, $
ENDSTYLE
END