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     [SOLVED] Outputting checkmark as an image or with a font to PPT

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Outputting checkmark as an image or with a font to PPT
 Login/Join
 
Member
posted
I have a requirement to have a green check mark and red X mark output in a grid report based on values in the data. I have read about this and figured out several ways that work just fine in HTML, but where I am getting tripped up is my report has to be output to PPTX format and it just doesn't work there.

 
TABLE FILE CAR
BY BODYTYPE
BY COMPUTE MARKER/A1 = IF BODYTYPE EQ 'SEDAN' THEN 'a' ELSE 'r'; AS 'Is this a sedan?'
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=DATA, COLUMN=MARKER, FONT='Webdings',WHEN= MARKER EQ 'a', COLOR=GREEN, $
TYPE=DATA, COLUMN=MARKER, FONT='Webdings',WHEN= MARKER EQ 'r', COLOR=RED, $
END
 


Example -- this uses Webdings font.. lower case 'a' in webdings is a check mark, lower case 'r' is a nice looking X mark. Outputs to HTML just fine, but when I output to PPTX format, it just shows the lower case 'a' and lower case 'r' in Courier New font, not what was specified in the stylesheet. I tried this technique with several different "symbol" fonts and had the same result, no matter what, the PPTX output for that field seems to be in Courier New font. The font are available IN powerpoint, so I can switch the output manually, but that won't work.

I also experimented with using images instead of symbol fonts... and once again, got it to work just fine in HTML, but when outputting to powerpoint it is totally broken.

Doing something with the stylesheet like TYPE=DATA,COLUMN=IMAGER,IMAGE=(IMAGER),SIZE=(15 15),PRESERVERATIO=ON,$ ...imager being a defined field that has the file name of the image. HTML works just fine, it's a nice small image and looks as expected, but when you flip the output over to PPTX what should be a small grid on a single slide becomes a 96 page powerpoint deck with lots of blank slides, broken images, etc.



So -- I've searched the forums and seen a decent amount of discussion on similar topics but most seem to be discussing HTML, PDF, or Excel output... curious to get thoughts on powerpoint output and if there are any suggestions.

Thanks in advance if anyone is able to help -- it would be much appreciated!

Jason

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


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Virtuoso
posted Hide Post
I don't think the WHEN syntax has anything to do with it since the COLOR is coming through properly.

It seems like some fonts are recognized and some aren't. If you change the font to Symbol the PPTX will assign Symbol font but Webdings don't come across. I'd call IB Tech Support to see if they have any idea why this is the case.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Platinum Member
posted Hide Post
Maybe it's a code page issue. I cannot get check marks to output to PDF or PPTX no matter which symbolic font I choose.

Did you open a case?


WebFOCUS 8.2.03 - Production
WebFOCUS 8.2.04 - Sand Box
Windows 2012 R2 Server
HTML, PDF, Excel
In FOCUS since 1980
 
Posts: 115 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Silver Member
posted Hide Post
Hi Jason-

We have embedded symbols in reports that are output to PPTX by using image files. In this example, my images are red and green dots instead of checkmarks. This technique came from an 8.1.05 Tech Bulletin so not certain it will work in your version.

TABLE FILE CAR
BY BODYTYPE
BY COMPUTE MARKER/A20 = IF BODYTYPE EQ 'SEDAN' THEN 'green_button.gif' ELSE 'red_button.gif'; AS 'Is this a sedan?'
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET STYLE *
$
TYPE=DATA, COLUMN=MARKER, IMAGE=(MARKER),SIZE=(.2 .2),$
TYPE=FOOTING,IMAGE='green_button.gif',position=(.122 .055), SIZE=(.2 .2),$
TYPE=FOOTING,LINE=1,ITEM=1,POSITION=.5,$
TYPE=FOOTING,IMAGE='red_button.gif',position=(.122 .33), SIZE=(.2 .2),$
TYPE=FOOTING,LINE=2,ITEM=1,POSITION=.5,$
END
   


Hope this helps!
Barb


WebFocus 8.1.05, 8.2.01
 
Posts: 32 | Registered: November 21, 2013Report This Post
Virtuoso
posted Hide Post
No need for FOOTING

TABLE FILE CAR
BY BODYTYPE
BY COMPUTE MARKER/A20 = IF BODYTYPE EQ 'SEDAN' THEN 'green_button.gif' ELSE 'red_button.gif'; AS 'Is this a sedan?'
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET STYLE *
$
TYPE=DATA, COLUMN=MARKER, IMAGE=(MARKER),SIZE=(.2 .2),$
END


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
quote:
Originally posted by BKinPA:
Hi Jason-

We have embedded symbols in reports that are output to PPTX by using image files. In this example, my images are red and green dots instead of checkmarks. This technique came from an 8.1.05 Tech Bulletin so not certain it will work in your version.

TABLE FILE CAR
BY BODYTYPE
BY COMPUTE MARKER/A20 = IF BODYTYPE EQ 'SEDAN' THEN 'green_button.gif' ELSE 'red_button.gif'; AS 'Is this a sedan?'
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET STYLE *
$
TYPE=DATA, COLUMN=MARKER, IMAGE=(MARKER),SIZE=(.2 .2),$
TYPE=FOOTING,IMAGE='green_button.gif',position=(.122 .055), SIZE=(.2 .2),$
TYPE=FOOTING,LINE=1,ITEM=1,POSITION=.5,$
TYPE=FOOTING,IMAGE='red_button.gif',position=(.122 .33), SIZE=(.2 .2),$
TYPE=FOOTING,LINE=2,ITEM=1,POSITION=.5,$
END
   


Hope this helps!
Barb


Barb -- thank you! This worked! I had been experimenting with this syntax but apparently hadn't been getting it quite right as this worked for me. Made my day.
Thank you,
Jason


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Member
posted Hide Post
quote:
Originally posted by MartinY:
No need for FOOTING

TABLE FILE CAR
BY BODYTYPE
BY COMPUTE MARKER/A20 = IF BODYTYPE EQ 'SEDAN' THEN 'green_button.gif' ELSE 'red_button.gif'; AS 'Is this a sedan?'
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET STYLE *
$
TYPE=DATA, COLUMN=MARKER, IMAGE=(MARKER),SIZE=(.2 .2),$
END


This is correct also -- I was experimenting with Barb's code and removed the footing and it still worked just the same without it. Thank you


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Member
posted Hide Post
Follow-up question on the images being output -- is there a way to align them not just in the center but vertically as well? So they are in the middle of whatever cell they are output to?


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Expert
posted Hide Post
This is unrelated to the image suggestions that were more recently discussed. The original question was concerned with specific font usage.

I just discovered that Calibri is not a valid font for PDF in WebFOCUS 7.7.05 - Developer Studio local reporting server - it works in HTML but displays as Courier in PDF. I dug into the file system and found file C:\ibi\DevStudio77\srv77\wfs\etc\fontuser.xml which states "This is the WebFOCUS user font map file, where users may add their own Type 1 PostScript fonts for use with PDF and PostScript reports" - I assume this may be valid for PowerPoint reports as well. There are detailed instructions on how to add a font family to the file - I haven't yet given this is a try - I find multiple copies of TrueType versions of Calibri on my PC, but no Type 1 PostScript.

I'm not sure why WebFOCUS requires Type 1 PostScript fonts for PDF (and perhaps for PowerPoint).


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
Expert
posted Hide Post
Calibri works for PDF in WebFOCUS 8.1.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     [SOLVED] Outputting checkmark as an image or with a font to PPT

Copyright © 1996-2020 Information Builders