[SOLVED] Subtotal wrapping up to length of 1st column
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
ThanksThis message has been edited. Last edited by: <Kathryn Henning>,
8.1.05 HTML,PDF,EXL2K, Active, All
April 15, 2014, 10:40 AM
Francis Mariani
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
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server