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.
Hi, We are needing to produce a report in PPT format and it has a need to have string / text to be displayed. We are trying to use the WRAP and the MARKUP functionality together as shown in the code below. WRAP is working fine if the MARKUP is not ON. But WRAP is not working if the MARKUP is ON. Have any of you faced this issue before with PPT output?
TABLE FILE CAR
PRINT
CAR
SEATS
HEADING
" "
FOOTING
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PPT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=.25 ,
RIGHTMARGIN=.15,
TOPMARGIN=1.05,
BOTTOMMARGIN=0.25,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
OBJECT=STRING, POSITION=(.25 1), DIMENSION=(6 1.5), TEXT='Welcome to your quarterly program summary', FONT=ARIAL, SIZE=23, COLOR=RGB(0 38 99),$
OBJECT=STRING, POSITION=(2.3 1.4), WRAP=ON, DIMENSION=(3 2), LINESPACING=MULTIPLE(2), FONT=ARIAL, SIZE=12, COLOR=RED
,TEXT='This is my text string. I wish I could format this in powerpoint. I would like to be able to seperate the paragraphs with an extra line, add bigger spaces between the lines, i.e. linespacing, be able to vertically align the column. Is this possible??',$
OBJECT=STRING, POSITION=(2.3 3.4), MARKUP=ON, DIMENSION=(3 2), LINESPACING=MULTIPLE(2), FONT=ARIAL, SIZE=12, COLOR=RED
, JUSTIFY=LEFT, TEXT='Above example has only [b]WRAP[/b] in it and it is working fine.<br>This contains only the [i]MARKUP[/i] in it.<br>This is also working fine.',$
OBJECT=STRING, POSITION=(.3 5.4), WRAP=ON, DIMENSION=(4 2),MARKUP=ON
,TEXT='<font face="Arial" size=12 color="Green">But the problem is using the WRAP and the MARKUP together. [i]WRAP[/i] is not working right in PPT while the [i]MARKUP[/i] is on. <BR>Is it a known thing? Or are we missing somthing?</font>',$
ENDSTYLE
END
This message has been edited. Last edited by: Kerry,
Regards, Kasi Krishnan WF 7.1.4 & WF 7.6.9: Databases - DB2, SQL Server 2000. OS: Windows & AIX
I managed to reproduce your issue in my 7.7.02M environment.
What you are using in your sample code seems to be right syntax and it should work, based on documentation about this feature in WebFOCUS New Features 7.6.9:
DN: 4500927.0509 Chapter 11: Reporting Language Enhancements Topic: Support for Markup Tags and Line Spacing Attributes in Text Boxes
I actually tested the sample code provided in the documentation and it displays the same behaviour. Wrapped output in PDF format as expected but no wrapping in PPT when WRAP=ON/MARKUP=ON.
SET PAGE-NUM=OFF
SET LAYOUTGRID=ON
TABLE FILE GGSALES
BY REGION NOPRINT
ON TABLE PCHOLD AS LINESP1 FORMAT PPT
ON TABLE SET STYLE *
type=report, size=8, $
object=string, position=(1 1), dimension=(7 3), wrap=on, markup=on, linespacing=multiple(3),
text='<b><font face="Arial" size=12>This paragraph is triple-spaced (LINESPACING=MULTIPLE(3)):</font></b> <full>Our <i>primary</i> goal for fiscal 2006 was to accelerate our transformation to customer centricity. In this letter, I?d like to give you an update on this work, which contributed to the 22-percent increase in earnings from continuing operations we garnered for fiscal 2006. Since the past is often prologue to the future, I?d like to describe how customer centricity is influencing not only our goals for fiscal 2007, but also our long-term plans. At Gotham Grinds, customer centricity means treating each customer as a unique individual, meeting their needs with end-to-end solutions, and engaging and energizing our Employees to serve them.</full>', $
ENDSTYLE
END