TABLE FILE CAR
SUM
COMPUTE DUMMY1/A400 =
       WARRANTY  || (' ' | STANDARD) ||
(' ' | WARRANTY) || (' ' | STANDARD) ||
(' ' | WARRANTY) || (' ' | STANDARD); AS ''

OVER

COMPUTE DUMMY2/A400 =
       STANDARD  || (' ' | WARRANTY) ||
(' ' | STANDARD) || (' ' | WARRANTY) ||
(' ' | STANDARD) || (' ' | WARRANTY); AS ''

BY COUNTRY

ON TABLE SET STYLE *
TYPE=REPORT, PAGESIZE=LETTER, ORIENTATION=LANDSCAPE, FONT='Arial', SIZE=9, BOTTOMGAP=.05, $$
TYPE=REPORT, COLUMN=DUMMY1, WRAP=5, COLOR=BLUE, $
TYPE=REPORT, COLUMN=DUMMY2, WRAP=5, COLOR=GREEN, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
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

quote:

Reference: Usage Notes for WRAP and SQUEEZE
Most Web browsers—by default—determine the width of a report column using an internal algorithm. If a data value exceeds the column's width, the browser wraps that data onto the next line of the column. If you want to prevent these line breaks, you can override this browser behavior by using the WRAP StyleSheet attribute.
Specifying a width is supported in HTML reports that generate an internal Cascading Style Sheet, as well as in PDF and PostScript reports.
The WRAP and SQUEEZE attributes are incompatible. You should not apply both of them to the same report component.
The OVER attribute is not supported with WRAP.
The WRAP attribute is for alphanumeric columns, and is not supported for text (TX) columns.

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

SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA

TABLE FILE CAR
SUM
COMPUTE DUMMY1/A400 =
       WARRANTY  || (' ' | STANDARD) ||
(' ' | WARRANTY) || (' ' | STANDARD) ||
(' ' | WARRANTY) || (' ' | STANDARD);
BY COUNTRY
ON TABLE HOLD AS H001
END

TABLE FILE CAR
SUM
COMPUTE DUMMY1/A400 =
       STANDARD  || (' ' | WARRANTY) ||
(' ' | STANDARD) || (' ' | WARRANTY) ||
(' ' | STANDARD) || (' ' | WARRANTY); AS ''
BY COUNTRY
ON TABLE HOLD AS H002
END

TABLE FILE H001
PRINT DUMMY1
BY COUNTRY
ON TABLE HOLD AS H003
MORE
FILE H002
END

TABLE FILE H003
PRINT
DUMMY1
BY COUNTRY

ON TABLE SET STYLE *
TYPE=REPORT, PAGESIZE=LETTER, ORIENTATION=LANDSCAPE, FONT='Arial', SIZE=9, BOTTOMGAP=.05, $$
TYPE=REPORT, COLUMN=DUMMY1, WRAP=5, COLOR=BLUE, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
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