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
Text Fields
 Login/Join
 
<BevS>
posted
I have seen numerous posts recommending changing the type of text fields to alpha to better handle reporting. I have a text field in a footer (so that it can span multiple columns) and it may be larger than my page size. I think that alpha fields are limited to 256 bytes anyway, but is there a way I can wrap the alpha field in the footer so that at least all 256 bytes show?
 
Report This Post
<Pietro De Santis>
posted
From the Creating Reports manual:

Including a Text Field in a Heading or Footing

You cannot apply the StyleSheet attribute WRAP to a text field, since a text field is
separated into multiple lines by the character count specified in the FORMAT attribute
in the Master File.
 
Report This Post
susannah
Expert
posted Hide Post
make your footer a table in itself.
FOOTING<br />"&MYFOOT"<br />where you have created<br />-SET &MYFOOT='<TABLE><TR><TD WIDTH="100%">' | &MYTEXTBLOCK || '</TABLE>';
any help?
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
<BevS>
posted
Susannah, I don't think your solution will work. I must create this report in PDF, and your code looks like HTML tags, right?
Pietro, The wrapping of the text field works fine, but using a text field makes Printplus not available. Without Printplus my subfoots are interspersed with my subtotals. I tried switching to an alpha field (although it has to truncate and is not really what I need) but I can't seem to wrap. I get an error when I try to wrap the subfoot.
I appreciate both of your replies....
 
Report This Post
dwf
Platinum Member
posted Hide Post
Have you tried breaking your alpha field into multiple fields?
For example:

DEFINE FILE whatever
FIELD1/A64 = SUBSTR(256,ALPHAFIELD,1,64,64,FIELD1);
FIELD2/A64 = SUBSTR(256,ALPHAFIELD,65,128,64,FIELD2);
FIELD3/A64 = SUBSTR(256,ALPHAFIELD,129,192,64,FIELD3);
FIELD4/A64 = SUBSTR(256,ALPHAFIELD,193,256,64,FIELD4);
END

Then display the four fields separately in the subfoot.
 
Posts: 135 | Location: Portland, OR | Registered: March 23, 2005Report This Post
<BevS>
posted
That works! Thank you.
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders