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]Arial Unicode MS font not retrieving the expected result

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Arial Unicode MS font not retrieving the expected result
 Login/Join
 
info4pal
Guru
posted
Hi,

Iam trying to print the Heavy Checkmark(✔) and the Heavy Ballot X(✘) in the report using the Arial Unicode MS font.In the report,if the seats are lesser than or equal to 3 then I want the ✔ symbol to get printed otherwise I need the ✘ symbol to be printed in the report.

But in the report ouput,Iam getting the values printed - &|#x2714; and &|#x2718; instead of the checkmark and the x symbol.

Could anyone please let me know if anything is wrong with my code and how to get the symbols printed instead of their values.

Thanks a lot in advance for all your help.

TABLE FILE CAR
PRINT
SEATS
COMPUTE COMP_VAL3/A10 = IF SEATS LE 3 THEN '&|#x2714;' ELSE '&|#x2718;';
BY COUNTRY
ON TABLE SET STYLE *
TYPE=REPORT,SQUEEZE=ON,FONT='Arial Unicode MS',SIZE=8,GRID=ON,BORDER=1.5,$
TYPE=DATA, COLUMN=N1, FONT='Arial',COLOR=BLACK,STYLE=NORMAL,$
TYPE=DATA, COLUMN=N2, FONT='Arial',COLOR=BLACK,STYLE=NORMAL,$
TYPE =DATA,COLUMN=N3, FONT='Arial Unicode MS',COLOR=RED,STYLE=BOLD,$
ENDSTYLE
END
-EXIT

This message has been edited. Last edited by: info4pal,


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Squatch
Master
posted Hide Post
I am getting the symbols when I use IE 9, Chrome, Firefox or App Studio's Internal Viewer. I appear to be on the same version of WebFOCUS as you are.


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
info4pal
Guru
posted Hide Post
Hi Squatch,

I have IE 11 on my machine and when I try running the report in developer studio 8105 version, I do not get the symbols printed Frowner

Any thoughts on what might be going wrong?

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Squatch
Master
posted Hide Post
I am assuming you have the Arial Unicode MS font installed on your computer. If it is definitely there, then run the report using IE 11 and view the source code (Right-click on browser window and select "View source").

You should see something like this:

<td>
[b]<font FACE="ARIAL UNICODE MS" size=1 color="#FF0000">✘</font>[/b]</td>
</tr>
<tr>
<td>
</td>
<td align=RIGHT>
<font FACE="ARIAL" size=1>2</font></td>
<td>
[b]<font FACE="ARIAL UNICODE MS" size=1 color="#FF0000">✔</font>[/b]</td>
</tr>

(Actually, I don't see the X or checkmark... this thread is converting the codes into symbols... you should see the codes instead.)


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Francis Mariani
Expert
posted Hide Post
Works in WF 8.0.08 and IE 11.

This message has been edited. Last edited by: Francis Mariani,


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
Squatch
Master
posted Hide Post
Dev Studio and WF 8.1.05 issue, maybe?


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Francis Mariani
Expert
posted Hide Post
This is an excerpt of the generated HTML:

<tr>
<td>
<font FACE="ARIAL" size=1>ENGLAND</font></td>
<td align=RIGHT>
<font FACE="ARIAL" size=1>2</font></td>
<td>
[b]<font FACE="ARIAL UNICODE MS" size=1 color="#FF0000">&#x2714;</font>[/b]</td>
</tr>
<tr>
<td>
</td>
<td align=RIGHT>
<font FACE="ARIAL" size=1>5</font></td>
<td>
[b]<font FACE="ARIAL UNICODE MS" size=1 color="#FF0000">&#x2718;</font>[/b]</td>
</tr>


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
info4pal
Guru
posted Hide Post
Hi Everyone,

Thanks for your solution/suggestion.
But I do not understand why is it not working (not showing the symbols) and just displaying the codes. Frowner

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Squatch
Master
posted Hide Post
Your browser's HTML code should look like the HTML code Francis posted.

Right-click on your report in IE 11 and select "View source". Compare that code with what Francis posted.


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
info4pal
Guru
posted Hide Post
Hi,

Thanks a lot everyone.
I had the htmlencoding turned on and hence it wasn't working.Now it is working fine.

Once again thanks a lot for all your help Smiler

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report 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]Arial Unicode MS font not retrieving the expected result

Copyright © 1996-2020 Information Builders