SET HIDENULLACRS=ON

TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS SEATS AS ' ' COLUMNS '5' AND '2' AND '3'
ON TABLE PCHOLD FORMAT HTML
END

This is how I want the Active report below to look

SET HIDENULLACRS=ON

TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS SEATS AS ' ' COLUMNS '5' AND '2' AND '3'
ON TABLE PCHOLD FORMAT AHTML
END


(there are no data items with 3 seats. and yes, the summing is meaningless

Any help always accepted. In the actual data I have six columns. And may have data in any or all of them.

Thank you

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

Will this work?

TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS SEATS AS ' ' 
ON TABLE PCHOLD FORMAT AHTML
END  

It could be that you want a certain sort in your across columns?

Sorry Don the sort order is the reason for using the across columns

I'd open a case as this looks like a bug. The HIDENULLACRS command works for HTML, PDF, EXL2K and APDF, but not for AHTML.