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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] PowerPoint Output

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] PowerPoint Output
 Login/Join
 
Gold member
posted
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
 
Posts: 71 | Registered: November 20, 2003Report This Post
Virtuoso
posted Hide Post
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



Looks like a case for Tech Support.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Expert
posted Hide Post
FYI, Kasi has a case with Support and it is being researched.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Expert
posted Hide Post
I'm just getting into Power Point formatted reports and came across this. The problem still occurs in v7.7.05.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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] PowerPoint Output

Copyright © 1996-2020 Information Builders