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.
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! MarilynThis message has been edited. Last edited by: mpbMDE,
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!
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.
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
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!!
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, 2005
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,