[SOLVED] The field in header going out of page width

December 26, 2018, 06:30 AM

Hi

The field in header is going out of page. The size has to be 10. And output is in PDF format.
Is there any way to move words to next line when the portrait page length finishes.

Regards
Ashwini Rane

This message has been edited. Last edited by: FP Mod Chuck,

December 26, 2018, 07:55 AM

S.J. Kadish

Please post your code so we can help you.

December 26, 2018, 10:12 AM

Doug

quote:
Please post your code so we can help you.

... Within the '< / >' tags in the above options.

December 26, 2018, 10:15 AM

Thanks for your willingness to help.
I am talking about the Oracle database field.
But for trial you can take static quote paste it in header by making sure that it's exceeding out of page in PDF and then handled this in such a way that it gets autofit or move to next line when it's exceeding.

Thanks in advance
Ashwini Rane

December 26, 2018, 10:25 AM

Doug

Ashwini,

A great/standard practice, here on Focal Point, is to duplicate your issue using a sample 'IBI source' such as 'The CAR File' and post that code within the '</>' tags in the above ribbon so that we can actually run it and see what the issue is.

December 26, 2018, 09:42 PM

 
TABLE FILE ibisamp/car
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON TABLE SUBHEAD
"Success is no accident. It is hard work, perseverance, learning, studying, sacrifice and most of all, love of what you are doing or learning to do."
ON TABLE PCHOLD FORMAT PDF
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET AUTOFIT OFF
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=TABHEADING, LINE=1, JUSTIFY=LEFT, $
TYPE=TABHEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='helvetica neue', SIZE=10, STYLE=NORMAL, $
ENDSTYLE
END

In the above code, the static quote is used as header. In actual there will be database field and length of the field could be from 0-100. The problem am facing is replicated successfully in above example and the requirement is, header should be auto fit or moved to next line.

Regards
Ashwini

December 27, 2018, 07:19 AM

Danny-SRL

If you use a TX format, the text will wrap. However, when I tried it, it does do the trick but the font and its size are ignored.

  
-SET &ECHO=ALL;
DEFINE FILE CAR
HEAD/TX60='Success is no accident. It is hard work, perseverance, learning, studying, sacrifice and most of all, love of what you are doing or learning to do.';
END
TABLE FILE car
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON TABLE SUBHEAD
"<HEAD "
ON TABLE PCHOLD FORMAT PDF
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET AUTOFIT OFF
ON TABLE SET STYLE *
INCLUDE=Warm.sty,$
TYPE=TABHEADING, LINE=1, JUSTIFY=LEFT, $
TYPE=TABHEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=10, STYLE=NORMAL, $
ENDSTYLE
END

December 27, 2018, 10:43 AM

David Briars

DEFINE FILE CAR
 MYTEXT/A256 = 'Success is no accident. It is hard work, perseverance, learning, studying, sacrifice and most of all, ' |
               'love of what you are doing or learning to do.  A little bit of WebFOCUS knowledge doesn''t hurt either.';
END 
-* 
TABLE FILE CAR
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON TABLE SUBHEAD
"<MYTEXT"
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
 UNITS=IN,$
 TYPE=TABHEADING, LINE=1, WRAP=3, FONT='ARIAL', COLOR = 'RED', $
ENDSTYLE
END

WRAP=3, in the code above, breaks the MYTEXT text into lines of up to three inches.

This message has been edited. Last edited by: David Briars,

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster