Focal Point
(FOC034)

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

November 07, 2007, 01:44 PM
slfmr
(FOC034)
I am getting this error:

(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 Smiler

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,$

TYPE=SUBFOOT,BY=1,LINE=2,ITEM=1,OBJECT=FIELD,JUSTIFY=RIGHT,STYLE=UNDERLINE,SIZE=10,WIDTH=5.95,COLSPAN=3,$
TYPE=SUBFOOT,BY=1,LINE=2,ITEM=2,OBJECT=FIELD,JUSTIFY=RIGHT,STYLE=BOLD,$

Thank you for your input!

Dev Studio 533 Server 533


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
November 07, 2007, 03:22 PM
Leah
I mean the actual column headings on the report not headings or footings.


Leah
November 07, 2007, 03:27 PM
slfmr
Not trying to be dense, but do you mean the column titles? I am not sure what the column headings are.

The longest column title I have is the word "Description" or "Adjustment Type"

Thank you


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
November 07, 2007, 03:30 PM
Tom Flynn
It's probably your &VARIABLES.
WRAP dosen't work in PDF, SQUEEZE does...

How'd you get 138 posts through w/o being asked to update your Profile

EDIT: Leah, SORRY!!! Missed the end of your initial post...

This message has been edited. Last edited by: Tom Flynn,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
November 07, 2007, 03:41 PM
slfmr
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.


Leah