Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Rendering Unicode characters
Go
New
Search
Notify
Tools
Reply
  
[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, 2005Reply With QuoteReport 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.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6270 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport 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, 2013Reply With QuoteReport 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: 1111 | Location: USA | Registered: January 27, 2015Reply With QuoteReport 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, 2003Reply With QuoteReport This Post
Master
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: 976 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport 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: 1663 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport 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.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6270 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport 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
 
Reply With QuoteReport 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: 5681 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport 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, 2013Reply With QuoteReport 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: 5681 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport 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, 2005Reply With QuoteReport 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, 2005Reply With QuoteReport 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: 5681 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport 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, 2005Reply With QuoteReport 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: 5681 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport 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.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6270 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport 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, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Rendering Unicode characters

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.