Hi All,

I am working on CSV format. below is my car example. If i run this example, country name, car and model label are coming in one line. Is it possible to display country name, car and model label in different rows?

 
TABLE FILE CAR
SUM 
     MODEL
BY  LOWEST MODEL
BY  LOWEST BODYTYPE
BY  LOWEST DEALER_COST
BY  LOWEST SEATS
BY  LOWEST RETAIL_COST
BY  LOWEST SALES
ACROSS COUNTRY AS ''
ACROSS CAR AS ''
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT COMT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     PAGESIZE='Envelope C3',
     LEFTMARGIN=1.000000,
     ORIENTATION=LANDSCAPE,
$
ENDSTYLE
END

 

Thanks in advance.

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

No, sorry. Whether you use COMT or DFIX with HEADER, it only produces 1 row for the column header. Since you , due to the ACROSSes had 3, it concatenates them all together into one, hence the ENGLAND JAGUAR MODEL . The same thing is true if I had a multi line column title, SALES AS 'THIS,IS,SALES' for instance. Then the HEADER in the output is
"THIS,IS,SALES" all on one line..