Is there a way to blank out - or suppress - subtotal labels? I've tried using: as ' ', but it does not work. Reporting in Excel format, does this make a difference?

Thanks for any help....vickie

Hi Vickie,

Here's an old trick that uses a dummy field that is set to a blank. I don't know if this will work in your case, but give it a try.

DEFINE FILE CAR
BLANK/A1 = ' ';
END
-*
TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
BY BLANK NOPRINT
BY CAR
ON BLANK SUBTOTAL AS ''
ON TABLE PCHOLD FORMAT EXL2K
END

Jim

Thanks, Jim....will try that and let you know how I make out.

vickie

Worked perfectly, Jim.

Many thanks...vickie