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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Case Opened] Rewrap TX field after linebreak

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Case Opened] Rewrap TX field after linebreak
 Login/Join
 
Platinum Member
posted
Hello WF people!

I am working on a report that has TX50 fields. I have successfully used
 
TYPE=REPORT,
LINEBREAK='CRLF',
$

to get the linebreaks to appear on the (PDF) report shown below.

The problem I now have is illustrated below: When there is a linebreak, the remainder of the characters for that line are creating a shortened first line of text in the next paragraph.
If you look at the word “Fridley”, it is the remainder of the TX50 line that is separated by the CRLF. So it terminates after the few remaining characters. If I redefine as TX140, I still have the same problem except with longer lines of text.

Is there a function or something that I can use to “restart” the text after the linebreak? In other words re-wrap the following text?

quote:
...
expected to use iCue to evaluate the effectiveness
of their instruction. [During the 2011-12 school would have finished the TX50 line length]

During the 2011-12 school
year the district focused on improving math
instruction for all students. At the elementary
schools a new math curriculum was purchased and
all staff including special education teachers
were trained on the new curriculum. [Fridley would have finished the TX50 line length]

Fridley
also became a Q-Comp district in 2005-06. All
staff, including special education, participated
in the process. This was a four part procedure:
Teacher evaluation, Staff development, Individual
...


Thanks in advance!
Marilyn

This message has been edited. Last edited by: mpbMDE,


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
Expert
posted Hide Post
I don't like your chances with this sort of issue with TX fields.

I am not aware of any functions that will work with TX fields.

Howe is this TX field shown in the PDf report ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
Sorry it has taken me SO long to respond. I didn't see any replies to the question until just now.

First off, thank you, Waz for responding.


To answer your question, the text above IS from the report. It can be pages and pages of text, with many of these instances where text like "During the 2011-12 school" and "Fridley" are like orphans on a new line for the reason stated.

Like you, I don't like my chances of getting this to work - at least not easily. What's at stake is the conversion of
Crystal Reports to WebFOCUS reports.

Any ideas or workarounds are certainly welcome...
Thanks!


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
Platinum Member
posted Hide Post
Just upgraded to v8.1.05


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
Expert
posted Hide Post
I assume that the upgrade gave you a solution.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
quote:
Waz...

The upgrade did NOT provide a solution.


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
Guru
posted Hide Post
quote:
LINEBREAK='CRLF'


Searching the IBI knowledge base here are a few links that might help. These links do not include TX type fields.

Are line-breaks in data fields supported?

Hard carriage return not respected with format PDF

Thank your for participating in the Focal Point Forum,
Tamra Colangelo
Focal Point Moderator
Information Builders


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Platinum Member
posted Hide Post
Thank you, Tamra.
That is exactly what I am doing. But it is not doing what is expected...


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
<Emily McAllister>
posted
Hi mpbMDE,

I think your problem is because you're not using alphanumeric format for your data. Is there any reason you are using TX?

Emily McAllister
Focal Point Moderator
 
Report This Post
Platinum Member
posted Hide Post
This data is thousands and thousands of characters long. (Many pages of text). If I were to define it as alphanumeric, it would exceed a WebFOCUS limit.


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
Platinum Member
posted Hide Post
It looks like there is not a way to convert this Crystal Report to WebFOCUS. The short, 'orphaned' lines of text are an issue!


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
Expert
posted Hide Post
Have you thought about asking IBI for suggestions ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
quote:
[Unsolved] Rewrap TX field after linebreak


Here are a few other suggestions:

How to control long field data to wrap on multiple lines

How to make a long string in subfoot Wrap using PDF format

Thank your for participating in the Focal Point Forum,

Tamra Colangelo
Focal Point Moderator
Information Builders


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Platinum Member
posted Hide Post
 
JOIN CLEAR *
JOIN
DISTRICTYEAR.DISTRICTYEAR.DISTRICTYEARID IN districtyear TAG DSTYR TO MULTIPLE
SIGNIFICANTTREND.SIGNIFICANTTREND.DISTRICTYEARID IN significanttrend TAG STREND
AS J1
END
JOIN
DISTRICTYEAR.DISTRICTYEAR.DISTRICTYEARID IN districtyear TO MULTIPLE
COMMUNITYINVOLVEMENT.COMMUNITYINVOLVEMENT.DISTRICTYEARID
IN communityinvolvement TAG COMMINV AS J2
END
JOIN
DISTRICTYEAR.DISTRICTYEAR.DISTRICTYEARID IN districtyear TO MULTIPLE
GOALPROCESS.GOALPROCESS.DISTRICTYEARID IN goalprocess TAG GOALPROC AS J3
END
JOIN
GOALPROC.GOALPROCESS.GOALPROCESSID IN districtyear TO MULTIPLE
GOAL.GOAL.GOALPROCESSID IN goal TAG GOAL AS J4
END
JOIN
DISTRICTYEAR.DISTRICTYEAR.DISTRICTYEARID IN districtyear TO MULTIPLE
LEADERSHIPPROCESS.LEADERSHIPPROCESS.DISTRICTYEARID IN leadershipprocess
TAG LDRPOC AS J5
END
JOIN
LDRPOC.LEADERSHIPPROCESS.LEADERSHIPPROCESSID IN districtyear TO MULTIPLE
LEADERSHIPMEMBER.LEADERSHIPMEMBER.LEADERSHIPPROCESSID IN leadershipmember
TAG LDRMEM AS J6
END
JOIN
DISTRICTYEAR.DISTRICTYEAR.DISTRICTYEARID IN districtyear TO MULTIPLE
MISSION.MISSION.DISTRICTYEARID IN mission TAG MISSION AS J7
END
JOIN
LDRMEM.LEADERSHIPMEMBER.DISTRICTPOSITIONID IN districtyear TO MULTIPLE
DISTRICTPOSITION.DISTRICTPOSITION.DISTRICTPOSITIONID IN districtposition
TAG DSTPOSN AS J8
END
JOIN
DISTRICTYEAR.DISTRICTYEAR.DISTRICTNUMBER AND DISTRICTYEAR.DISTRICTYEAR.DISTRICTTYPE IN districtyear TO MULTIPLE
UVW_MNCIMP_MONITORSCHEDULE.UVW_MNCIMP_MONITORSCHEDULE.DISTRICTNUMBER AND UVW_MNCIMP_MONITORSCHEDULE.UVW_MNCIMP_MONITORSCHEDULE.DISTRICTTYPE
IN uvw_MNCIMP_MonitorSchedule TAG MSCHD AS J0
END

-* convert belief statements to end with '.'
DEFINE FILE districtyear
DISTRICT/A43= DISTRICTNUMBER || '-' || (DISTRICTTYPE | ' ' | DISTRICTNAME);
NXT_MONITORYEAR/A5 = IF MONITORYEAR GT '13-14' THEN MONITORYEAR ELSE '99-99';
CR/A1= HEXBYT(13,'A1');
CRLF/A2= HEXBYT(13,'A1')|HEXBYT(10,'A1');
LF/A1= HEXBYT(10,'A1');
END

TABLE FILE districtyear
WHERE SCHOOLYEAR EQ '13-14'
WHERE DISTRICTNUMBER EQ '0014'
WHERE DISTRICTTYPE EQ '01'
PRINT
SIGNIFICANTTREND
BY DISTRICT NOPRINT
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.50000,
     BOTTOMMARGIN=0.50000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
     SUMMARY='General District Information',
     TITLETEXT='General District Information',
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     STYLE=NORMAL,
$
TYPE=REPORT,
LINEBREAK='CRLF',
$
ENDSTYLE
END


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
Platinum Member
posted Hide Post
An update: IBI has been working on this case since January of 2017. There has not been even a hope of any progress as of today. Over the course of the last few weeks, she is again asking me for files that were requested and attached in Feb of this year.
This leads me to the conclusion that IBI has no concern whatsoever about WebFOCUS inability to accommodate some data types. (TX50) How very frustrating!!


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
Virtuoso
posted Hide Post
You have two separate operations controlling (and fighting over) line breaks.

For TX50, Focus (ignoring the assigned font, and thinking in terms of a band printer) inserts a new-line every so often (at a word break), to place up to 50 characters on each line.

For PDF formatting, resulting lines whose width (based on the assigned font) exceeds the assigned line width get wrapped -- but the newlines that the first process inserts are respected.

So, either use a fixed-width font for your TX50 field, so that 50 characters will fit within the width assigned to the report column; or increase the assigned column width so that even lines of 50 characters with a bunch of W's won't exceed it.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Platinum Member
posted Hide Post
I tried that. It has no effect on the wrapping. Same problem still exists. Thanks for the thought, though!

You are correct in saying that "For TX50, Focus (ignoring the assigned font, and thinking in terms of a band printer) inserts a new-line every so often (at a word break), to place up to 50 characters on each line."

What happens is that the data has paragraph breaks in it. So the addition of the new-line ignores the pre-existing line-breaks. So when the WebFOCUS inserted line-break is just a few characters after the double line-break [New line + skip line for new paragraph] in the data, the result is a beginning paragraph line that is just a few characters long.
For example the end of the paragraph is:
"increase from 35.28 percent in 2004-05." The next characters are 2 line-breaks. [And these 2 line-breaks count within the 50 characters.] The next line "Over" is the end of the WebFOCUS inserted 50 character line-break - so the WebFOCUS inserted line-break kick in and leaves the "Over" on a line all by itself. The next line restarts WF 50 character count and is the appropriate length.
If WF would respect the line-breaks in the data, this would not happen.

This message has been edited. Last edited by: mpbMDE,


WebFOCUS 8.1.05 Windows 7, all output
 
Posts: 107 | Registered: February 18, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Case Opened] Rewrap TX field after linebreak

Copyright © 1996-2020 Information Builders