Focal Point
[Solved]Wrap text on ROW-TOTAL AS Name

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9617069986

April 17, 2018, 11:16 AM
ChadSS
[Solved]Wrap text on ROW-TOTAL AS Name
I need to wrap the text on my ROW-TOTAL and so far I have not been successful. I would like the text to wrap after the word 'billed'. Any suggestions?

 TABLE FILE CAR
SUM
     DEALER_COST
ACROSS COUNTRY NOPRINT
ACROSS CAR AS ' '
ON TABLE ROW-TOTAL AS 'Total Amount Billed (Current Period)'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$
TYPE=TITLE,
     COLUMN=ROWTOTAL(1),
     COLOR='RED',
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE,
     ACROSS=2,
     COLUMN=ROWTOTAL(1),
     COLOR='RED',
     STYLE=BOLD,
     JUSTIFY=CENTER,
	 WRAP=0.250000,
$
TYPE=REPORT,
     COLUMN=N2,
     WRAP=0.250000,
$
ENDSTYLE
END



WebFOCUS 7.703

This message has been edited. Last edited by: ChadSS,
April 17, 2018, 11:45 AM
FP Mod Chuck
Hi Chad

Try this...


TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
ACROSS CAR.ORIGIN.COUNTRY NOPRINT
ACROSS CAR.COMP.CAR AS ' '
ON TABLE ROW-TOTAL AS 'Total Amount Billed (Current Period)'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$
TYPE=REPORT,
WRAP=1.5,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(1),
COLOR='RED',
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE,
ACROSS=2,
COLUMN=ROWTOTAL(1),
COLOR='RED',
STYLE=BOLD,
JUSTIFY=CENTER,
$
ENDSTYLE
END



Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
April 17, 2018, 11:51 AM
Francis Mariani
Try
TYPE=REPORT, COLUMN=ROWTOTAL(1), WRAP=0.25, $



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
April 17, 2018, 11:56 AM
ChadSS
 $
TYPE=REPORT,
 WRAP=1.5,
$


That does work, but unfortunately affects all fields within the report. I wanted to isolate the wrap to the one field.
April 17, 2018, 12:01 PM
ChadSS
quote:
Originally posted by Francis Mariani:
Try
TYPE=REPORT, COLUMN=ROWTOTAL(1), WRAP=0.25, $


I tried that without success. I actually found it in one of your posts from years ago.
April 17, 2018, 12:04 PM
Francis Mariani
Seems to work for me:



-* File chadss_1.fex
TABLE FILE CAR
SUM
     CAR.BODY.DEALER_COST
ACROSS CAR.ORIGIN.COUNTRY NOPRINT
ACROSS CAR.COMP.CAR AS ' '
ON TABLE ROW-TOTAL AS 'Total Amount Billed (Current Period)'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$
TYPE=TITLE,
     COLUMN=ROWTOTAL(1),
     COLOR='GREEN',
     STYLE=BOLD,
     JUSTIFY=LEFT,
$
TYPE=ACROSSVALUE,
     ACROSS=2,
     COLUMN=ROWTOTAL(1),
     COLOR='RED',
     STYLE=BOLD,
     JUSTIFY=LEFT,
$
TYPE=REPORT,
     COLUMN=N2,
     COLOR='BLUE',
     WRAP=0.250000,
$

TYPE=REPORT, COLUMN=ROWTOTAL(1), WRAP=1.0, $

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
April 17, 2018, 12:28 PM
ChadSS
quote:
TYPE=REPORT, COLUMN=ROWTOTAL(1), WRAP=1.0, $


Francis, as always, you are correct. I neglected to add the COLUMN=ROWTOTAL with the TYPE=REPORT. I was using it with the TYPE=ACROSSVALUE. Thanks for your help