Focal Point
PDF Stylesheet problem: WRAP with OVER doesn't work properly

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

February 05, 2007, 02:07 PM
Francis Mariani
PDF Stylesheet problem: WRAP with OVER doesn't work properly
Has anyone else encountered the following problem with PDF reports?

I use WRAP in the style-sheet to control the width of a report column. Since the report rows are created using OVER, I specify WRAP for the two fields that are one over the other.

Here's a snippet of report code:

TABLE FILE R026H030
PRINT
P1_PERIOD_END_DT              AS ''

P1_CUST_NMX                   AS ''

P1_PROV_STAT_NAMEX            AS ''

P1_C_CUR_RISK_RTG_CD          AS ''
P1_C_PRO_RISK_RTG_CD          AS ''

...

OVER

P2_PERIOD_END_DT              AS ''

P2_CUST_NMX                   AS ''

P2_PROV_STAT_NAMEX            AS ''

P2_C_CUR_RISK_RTG_CD          AS ''
P2_C_PRO_RISK_RTG_CD          AS ''

...

Here's a snippet of style-sheet code:

...

TYPE=REPORT, COLUMN=P3,  WRAP=2.0, $
TYPE=REPORT, COLUMN=P19, WRAP=2.0, $

TYPE=REPORT, COLUMN=P4,  WRAP=0.7, $
TYPE=REPORT, COLUMN=P20, WRAP=0.7, $

TYPE=REPORT, COLUMN=P13, WRAP=2.0, $
TYPE=REPORT, COLUMN=P29, WRAP=2.0, $

TYPE=REPORT, COLUMN=P5,  RIGHTGAP=0.1, $
TYPE=REPORT, COLUMN=P21, RIGHTGAP=0.1, $

...

Here's the problem:

The columns after OVER (the second row) that I have WRAP specified for are displayed without the second line of the wrapped text.

This message has been edited. Last edited by: Francis Mariani,


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
February 05, 2007, 03:22 PM
FrankDutch
Francis

I would go for a totally other solution to avoid the "over" solution, but that was not your question.

Do the other columns have a fixed width too?
I mean all the columns.

Frank




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

February 05, 2007, 03:38 PM
Francis Mariani
I don't use WRAP for any other of the report columns.

I need to use MATCH to merge two extract files. I suppose I could separate the data back to two individual files after the MATCH and then use MORE to include both of them in the report.

Hmmmm - some food for thought, thank you Frank.


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
February 05, 2007, 03:47 PM
FrankDutch
yes that is what I should do.
mayb add a codefield (source) to the both so you can see which record comes from file A and which from file B.
In the final report you can say

PRINT ....
BY borrowercode etc...
BY source...




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7