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]Rendering Unicode characters

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Rendering Unicode characters
 Login/Join
 
Virtuoso
posted
I need to produce stock-listing type output, with an up or down arrow-head symbol to indicate positive or negative change in the measure.

For example,

▲ 23.45%

or

▼ -3.21%


I have the Unicode values for the two arrowhead synbols: ▲ = Unicode 25B2, ▼ = Unicode 25BC
and I can stuff those values into a define within a fex.

But when I execute it, the symbols render as "?". Apparently, WF welcomes Unicode in the source code, but reverts to a 265-character alphabet at execution time.

I would rather use this method than graphics -- if I can get it to work with the symbols as text, the result should port nicely across output file formats (html, pdf, etc); and styling can be used to uniformly color the data and the symbol.

Suggestions?

(Currently using 8.1)

This message has been edited. Last edited by: <Emily McAllister>,


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Expert
posted Hide Post
Don't you need to set the codepage somewhere ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
We are on UTF-8 setup and I can easily use ▲ in field titles. I remember there was some workaround to get delta in titles or to text with "D" and assigning special FONT for data or title.
Unfortunately I was not able to find this workaround


Release: WebFOCUS 8104, AppStudio: 8105
OS: Windows
Output: HTML,Excel,Active Reports
 
Posts: 89 | Registered: November 19, 2013Report This Post
Virtuoso
posted Hide Post
Have you tried this syntax?:

COMPUTE HTMLENTITY/A9 = '&|#x25B2;';

or 

COMPUTE HTMLENTITY/A50 = '<span style="font-size:50px">&|#x25B2;</span>';

to change size...


Works on my end.

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


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Platinum Member
posted Hide Post
Make sure both WebFOCUS Server & Client Code Page are 65001

Make sure your Web Server is configured to process UTF-8

Make sure that your Web Browser is set to either Auto Detect or UTF8
 
Posts: 164 | Registered: March 26, 2003Report This Post
Virtuoso
posted Hide Post
Anybody that wants to speak to this in pdf format as well I'm all ears. We've been trying to get a "less-than-or-equal-to" character into a pdf doc for years. We tried all these tricks.

No reason it shouldn't work but it douldn't work.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Virtuoso
posted Hide Post
Be careful when you set your servers to code page 65001.
Doing so increases the space requirements for character fields in HOLD-files and can cause fields that previously had no issues fitting in a segment to no longer do so.

That's something we ran into over the weekend, which in our case was quite obvious as it was a HOLD-file in a process that manages authorization to our custom portal - nothing worked at all. Thankfully, that was our test server.

The trouble is, there will probably be cases where this happens, and AFAIK there is no way to know where those will happen until you switch to UTF-8. You'll be chasing the effects for a while.

Or is there some magic trick here? Would love to hear if that's the case.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Expert
posted Hide Post
Another option would be to use images to the up and down.

May have issues with excel though


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
<Emily McAllister>
posted
Hello,

You should be able to include those characters without a problem if your codepage is in fact set to 65001.
To help troubleshoot, I would first run the code directly off the Reporting Server. If you get question marks then your issue is there. If it works then you should examine your client.

Let us know your results so we can help you more if needed.
Thanks,
Emily McAllister
Focal Point Moderator
 
Report This Post
Expert
posted Hide Post
Hi Jack,

Are you still looking for this? I can get it in HTML using the following code, but of course it is no good for PDF or MS Excel.

      COMPUTE GRAPHIC/A8 = IF PCENT GT 0 THEN '&|#x25B2;'
                      ELSE IF PCENT LT 0 THEN '&|#x25BC;'
                      ELSE '&|#x25C0;';


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Master
posted Hide Post
For PDF, you need to make sure that font contains the symbol you are looking for. I would suggest using a Unicode font also.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Expert
posted Hide Post
Managed to get something working for HTML, PDF and EXL07. Not exactly the character that you were looking for but still up and down arrows -

TABLE FILE GGSALES
  SUM DOLLARS
      COMPUTE PCENT/D7.2% = 100 - (DOLLARS / BUDDOLLARS * 100);
      COMPUTE UPDOWN/A1  = IF PCENT GT 0 THEN 'U'
                     ELSE IF PCENT LT 0 THEN 'D'
                     ELSE 'E'; NOPRINT
      COMPUTE ARROW1/A1 = IF PCENT GT 0 THEN HEXBYT(221,'A1')
                     ELSE IF PCENT LT 0 AND &WFFMT.QUOTEDSTRING EQ 'EXL07' THEN HEXBYT(223,'A1')
                     ELSE IF PCENT LT 0 THEN HEXBYT(160,'A1')
                     ELSE HEXBYT(219,'A1');
   BY STCD
ON TABLE PCHOLD FORMAT '&WFFMT.(HTML,PDF,EXL07).Format.'
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
  grid=off, size=10, $
  type=data, column=PCENT, color=green, when=UPDOWN EQ 'U', $
  type=data, column=PCENT, color=orange, when=UPDOWN EQ 'E', $
  type=data, column=PCENT, color=red, when=UPDOWN EQ 'D', $
  type=data, column=ARROW1, font=Symbol, $
  type=data, column=ARROW1, color=green, when=UPDOWN EQ 'U', $
  type=data, column=ARROW1, color=orange, when=UPDOWN EQ 'E', $
  type=data, column=ARROW1, color=red, when=UPDOWN EQ 'D', $
ENDSTYLE
END
-RUN


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
Tony, in our environment, HTML renders the up arrow, but the down arrow is blank. In PDF the up arrows renders as a Euro symbol. Both arrows work properly in EXL07.


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
'Wingdings 3' works for HTML, EXL07 and EXL2K. It does not work for PDF. But perhaps the Postscript font can be added...

TABLE FILE CAR
PRINT 
COMPUTE UP/A1 = 'p';
COMPUTE DOWN/A1 = 'q';
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=UP, FONT='Wingdings 3', COLOR=GREEN, $
TYPE=DATA, COLUMN=DOWN, FONT='Wingdings 3', COLOR=RED, $
ENDSTYLE

ON TABLE PCHOLD FORMAT EXL07
END

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
Expert
posted Hide Post
Also tried WebDings using chars 53, 54 & 51 respectively - these are actually the blocked arrow heads. OK in HTML and EXL07 but no good in PDF but that may be because I need to use a font configured in PDF for WF.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
From a cursory glance at articles regarding Wingdings, it is suggested it is preferable to use Unicode. It looks like there are only TrueType and OpenType versions of this common Microsoft font.

Apparently it isn't easy to use Unicode in PDF, so we seem to be stuck.


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
quote:
it isn't easy to use Unicode in PDF

You can say that again!

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
You can add other fonts to be available to PDF.

There is a process and tools out there to prepare the necessary files.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
@Francis -- That's just what I needed. I only need this in Excel (XLSX), so Wingdings3 fills the bill.

Much thanks.

-Jack
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 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]Rendering Unicode characters

Copyright © 1996-2020 Information Builders