(FOC034) THE PRINT LINE EXCEEDS THE MAXIMUM LINE WIDTH. WIDTH IS: 619
The procedure works standalone. When I run the fex that compounds this report with another it causes a problem... likethis:
SET COMPOUND='OPEN' EX fex1 var1='&var1', var2='&var2' EX fex2 var1='&var1', var2='&var2' SET COMPOUND=CLOSE EX fex3 var1='&var1', var2='&var2'
I have tried SET PANEL, SET WIDTH, and SET SPACES and when using SET PANEL, I get the report but in the html text format or something that is not PDF or EXCEL... which is the format I am passing.
Are there any other things I can try?
Thank you
Dev, SIT, UAT, Production:7.6.6 Dev Sandbox:7.6.11
Dev Studio - 7.6.6
November 07, 2007, 02:16 PM
Leah
Sometimes it's not the data but the headings that are 'killing you'. What version of WebFOCUS are you on? You don't show it in your signature.
Leah
November 07, 2007, 02:33 PM
slfmr
Oh yes, I use many different versions for the Server and Dev Studio
The server and Dev Studio are 533 but I get the error when using either.
Thank you, Stacy
Dev, SIT, UAT, Production:7.6.6 Dev Sandbox:7.6.11
Dev Studio - 7.6.6
November 07, 2007, 02:41 PM
Leah
Are you using field names as the column headings and if so are they long names?
Leah
November 07, 2007, 03:07 PM
slfmr
So I have 2 field subfoots and a heading and footing.
The heading is very small but both subfoots are using fields in them. The longest column title is "Description".
The Subfoot lengths are A88 with a D20.2 The other subfoot is: A29 with a D20.2
I have 6 columns wrapped as follows: TYPE=REPORT,COLUMN=N1,WRAP=0.000000,$ TYPE=REPORT,COLUMN=N2,WRAP=2.500000,$ TYPE=REPORT,COLUMN=N3,WRAP=2.000000,$ TYPE=REPORT,COLUMN=N4,WRAP=1.200000,JUSTIFY=RIGHT,$ TYPE=REPORT,COLUMN=N5,WRAP=1.200000,JUSTIFY=RIGHT,$ TYPE=REPORT,COLUMN=N6,WRAP=2.000000,$
The subfoots: TYPE=SUBFOOT,HEADALIGN=BODY,$ TYPE=SUBFOOT,BY=2,LINE=2,ITEM=1,OBJECT=FIELD,JUSTIFY=RIGHT,STYLE=UNDERLINE,WIDTH=5.95,COLSPAN=3,$ TYPE=SUBFOOT,BY=2,LINE=2,ITEM=2,OBJECT=FIELD,JUSTIFY=RIGHT,STYLE=BOLD,$
Okay I will try playing with the wrap, width and squeeze.
Thank you.This message has been edited. Last edited by: slfmr,
Dev, SIT, UAT, Production:7.6.6 Dev Sandbox:7.6.11
Dev Studio - 7.6.6
November 07, 2007, 04:21 PM
Leah
No problem Tom and yes I meant column title. If the total characters in the column titles is too many based on the number of columns, the version ou are on is not liked.