This client is running WebFOCUS 7.6.10 on an i-Series / AS400 server. The database is DB2. The report requirement is to list pairs of columns from one table OVER the next pair. The problem is that the second field in each pair is format A800. I.E.
TEXT1 COMMENT1 TEXT2 COMMENT2 TEXT3 COMMENT3
For some reason that I cannot figure out, the WRAP command works fine for the first pair of fields, but not for any that follow the OVER statement. Here is an example using CAR:
[code}
DEFINE FILE CAR COMMENT1/A800=WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY | WARRANTY; COMMENT2/A800=CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD | CAR.EQUIP.STANDARD; END TABLE FILE CAR PRINT 'CAR.ORIGIN.COUNTRY' AS ' ' 'CAR.WARANT.COMMENT1' AS ' ' OVER 'CAR.COMP.CAR' AS ' ' 'CAR.WARANT.COMMENT1' AS ' ' HEADING "" FOOTING "" WHERE CAR.CARREC.MODEL EQ 'TR7'; ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE=REPORT, GRID=ON, FONT='ARIAL', SIZE=9, $ TYPE=TITLE, STYLE=BOLD, $ TYPE=TABHEADING, SIZE=12, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=12, STYLE=BOLD, $ TYPE=HEADING, SIZE=12, STYLE=BOLD, $ TYPE=FOOTING, SIZE=12, STYLE=BOLD, $ TYPE=SUBHEAD, SIZE=10, STYLE=BOLD, $ TYPE=SUBFOOT, SIZE=10, STYLE=BOLD, $ TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $ TYPE=ACROSSVALUE, SIZE=9, $ TYPE=ACROSSTITLE, STYLE=BOLD, $ TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $ TYPE=REPORT, COLUMN=N1, WRAP=1.000000, $ TYPE=REPORT, COLUMN=N2, WRAP=7.000000, $ TYPE=REPORT, COLUMN=N3, WRAP=1.000000, $ TYPE=REPORT, COLUMN=N4, WRAP=7.000000, $ ENDSTYLE END [/code]
Any suggestions would be greatly appreciated.This message has been edited. Last edited by: Kerry,
Robert F. Bowley Jr. Owner TaRa Solutions, LLC
In WebFOCUS since 2001
July 28, 2010, 05:39 PM
Francis Mariani
This looks suspiciously like a bug!
Try as I might, I couldn't get two long fields to WRAP in the PDF report.