Hello to all.

When I have a WHERE TOTAL and I want to show the sort field value in my SUBTOTAL lines, I use SET PRINTPLUS = ON but it looks like it doesn't work with Excel output!!

SET PRINTPLUS = ON
TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
ON COUNTRY SUBTOTAL AS 'Stotal for '
WHERE TOTAL ( DEALER_COST LT 8000 );
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT 'EXL2K'
ON TABLE SET HTMLCSS ON
END

The sort field value shows up with HTML or PDF but not EXL2K.

What can I do????

We are using 5.2.5

Thanks

Well after thinking about it, I found an work-around... It really looks like it's a bug but you can simply put the result of the table file in a hold file and then do your table file on it without the WHERE TOTAL.

TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
WHERE TOTAL ( DEALER_COST LT 8000 );
ON TABLE HOLD AS HCAR
END
TABLE FILE HCAR
SUM
DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
ON COUNTRY SUBTOTAL AS 'Stotal for '
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT 'EXL2K'
ON TABLE SET HTMLCSS ON
END

A little longer but reading from a hold file is quick.