Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
(FOC034)
 Login/Join
 
Platinum Member
posted
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
 
Posts: 178 | Registered: May 11, 2005Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 178 | Registered: May 11, 2005Report This Post
Virtuoso
posted Hide Post
Are you using field names as the column headings and if so are they long names?


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 178 | Registered: May 11, 2005Report This Post
Virtuoso
posted Hide Post
I mean the actual column headings on the report not headings or footings.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 178 | Registered: May 11, 2005Report This Post
Expert
posted Hide Post
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
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 178 | Registered: May 11, 2005Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders