Hello

I am having problem with sub-total text getting wrapped up to length of 1st column. Below is the sample code with CAR files

  
DEFINE FILE CAR
  SORT_DESC/A25 = 'ITALY SALES REPORT';
END

TABLE FILE CAR
SUM
	CAR
	SALES
	RETAIL_COST
BY SORT_DESC
BY COUNTRY
WHERE COUNTRY EQ 'ITALY';
ON TABLE HOLD AS H1
END

DEFINE FILE CAR
  SORT_DESC/A25 = 'ENGLAND SALES REPORT';
END

TABLE FILE CAR
SUM
	CAR
	SALES
	RETAIL_COST
BY SORT_DESC
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS H2
END

TABLE FILE H1
SUM
	CAR
	SALES
	RETAIL_COST
BY SORT_DESC
BY COUNTRY
ON TABLE HOLD AS H3
MORE
FILE H2
END

TABLE FILE H3
SUM
	CAR
	SALES
	RETAIL_COST
BY SORT_DESC NOPRINT
BY COUNTRY AS ''
ON SORT_DESC SUB-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=PTS,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT, COLUMN=N2, SQUEEZE=45, JUSTIFY=LEFT, $
TYPE=REPORT, COLUMN=N3, SQUEEZE=125, JUSTIFY=LEFT, $
TYPE=GRANDTOTAL, STYLE=BOLD,$
TYPE=SUBTOTAL, STYLE=BOLD,$
ENDSTYLE
END

I am trying to get Total ENGLAND SALES REPORT extend towards 2nd column (CAR) as well so that it doesn't get wrapped up. I tried using SUBFOOT and got a result but I want to avoid SUBFOOT

Please suggest

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

Maybe change the last TABLE FILE to:

TABLE FILE H3
SUM
	SALES
	RETAIL_COST
BY SORT_DESC NOPRINT
BY COUNTRY AS ''
BY CAR AS ''
ON SORT_DESC SUB-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=PTS,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT, COLUMN=N2, SQUEEZE=45, JUSTIFY=LEFT, $
TYPE=REPORT, COLUMN=N3, SQUEEZE=125, JUSTIFY=LEFT, $
TYPE=GRANDTOTAL, STYLE=BOLD,$
TYPE=SUBTOTAL, STYLE=BOLD,$
ENDSTYLE
END

worked perfect francis...thank u...