Hi there.

If I try to create a simple table with across like this:

TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
BY  LOWEST CAR.BODY.BODYTYPE
ACROSS LOWEST CAR.BODY.SEATS
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=ACROSSVALUE,
     ACROSS=1,
     BACKCOLOR='WHITE',
$
ENDSTYLE
END
  

The title of the DEALER_COST column is missing. But if I add another column in the SUM works fine, both column title appear.

Any help on this problem?

Thanks,
Carlos Dias

This message has been edited. Last edited by: Carlos Dias,

Carlos,
This is a feature of ACROSS.
To circumvent this feature you can do the following:

  
TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST/D7
BY  LOWEST CAR.BODY.BODYTYPE
ACROSS LOWEST CAR.BODY.SEATS
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=ACROSSVALUE,
     ACROSS=1,
     BACKCOLOR='WHITE',
$
ENDSTYLE
END

Thanks for the answer.
Works fine.

Even prettier:

  
TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST/D7
BY  LOWEST CAR.BODY.BODYTYPE
ACROSS LOWEST CAR.BODY.SEATS
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET HTMLCSS ON
ON TABLE SET ACROSSTITLE SIDE
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=ACROSSVALUE,
     ACROSS=1,
     BACKCOLOR='WHITE',
$
ENDSTYLE
END