Simple request, works fine returning HTML and PDF, but loses styling on SEATSPER when returning EXL2K (NOTE - styling on CNT.CAR doesn't work in any form...why's that?). I've searched the postings, but cannot find this answer. It's the SEATSPER that I really care about... the others were just interesting notes.

  
DEFINE FILE CAR 
 CARTOT/I9 WITH BODYTYPE=1; 
END
TABLE FILE CAR
SUM CNT.BODYTYPE 
    CARTOT 
COMPUTE SEATSPER/D6.1=SEATS/CARTOT; 
BY COUNTRY 
ACROSS BODYTYPE
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA,ACROSSCOLUMN=CNT.BODYTYPE,COLOR=RED,WHEN=CNT.BODYTYPE GT 1,$
TYPE=DATA,ACROSSCOLUMN=CARTOT,COLOR=RED,WHEN=CARTOT GT 1,$
TYPE=DATA,ACROSSCOLUMN=SEATSPER,COLOR=RED,WHEN=SEATSPER GT 3,$
ENDSTYLE 
END 

Is it a dumb error, or is Excel messing with me?

... sorry for the lousy looking first post.. and I updated my profile as well.

Thanks
Scott

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

Zoogy,

It seems to me that you should not use the acrosscolumn name but its number:

  
DEFINE FILE CAR 
 CARTOT/I9 WITH BODYTYPE=1; 
END
TABLE FILE CAR
SUM CNT.BODYTYPE 
    CARTOT 
COMPUTE SEATSPER/D6.1=SEATS/CARTOT; 
BY COUNTRY 
ACROSS BODYTYPE
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA,ACROSSCOLUMN=N1,COLOR=RED,WHEN=CNT.BODYTYPE GT 1,$
TYPE=DATA,ACROSSCOLUMN=N2,COLOR=RED,WHEN=CARTOT GT 1,$
TYPE=DATA,ACROSSCOLUMN=N3,COLOR=RED,WHEN=SEATSPER GT 3,$
ENDSTYLE 
END 

Zoogy,

Please notice that even using its number for CNT.BODYTYPE the style still does not work. You have to either compute a new field like SEATSPER or create one in the define as you did with CARTOT.