Focal Point
SOLVED : per thousand (mille) sign

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/929104704

March 30, 2010, 10:57 AM
JACQUETL
SOLVED : per thousand (mille) sign
Hi,

We want to print per thousand sign near a print value.
How can i do this ?
I will know hex code is 89 but it don't work.
But maybe i must configure "Table Microsoft® Windows Latin-1" but how ?

Thanks.

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


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
March 30, 2010, 11:41 AM
Alan B
Try
TABLE FILE CAR
SUM COMPUTE PCT.SALES
COMPUTE TSALES/D12.2 = PCT.SALES/10; AS '&|#8240;'
BY COUNTRY
END



Alan.
WF 7.705/8.007
March 30, 2010, 12:02 PM
njsden
quote:
I must configure "Table Microsoft® Windows Latin-1" but how ?

In general when dealing with "extended characters" make sure that both your WebFOCUS Client and Reporting Server use a CodePage=137 [U.S English/Western Europe (Latin 1)].

See NLS Settings in WebFOCUS Administration Console (Client) and Web Console (Server).

- Neftali.

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



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.
March 30, 2010, 12:09 PM
Alan B
When using the character entity codes, these are handled by the browser, not WebFOCUS. Changing a codepage makes no difference. I use 437 and of course the permil comes through fine.


Alan.
WF 7.705/8.007
March 30, 2010, 12:22 PM
njsden
quote:
When using the character entity codes, these are handled by the browser


Jacquetl did not specify whether or not the intended output was exclusively HTML. His/her signature specifies PDF as well so the entity code recognised by HTML may not be applicable in that case.



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.
March 31, 2010, 02:46 AM
JACQUETL
Good Alan B. It work fine with html format.

But is it possible with PDF format ?


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
April 01, 2010, 04:55 AM
<JJI>
Alan,

I tried your example but I'v got this error:
(FOC844)  UNCORRECTABLE SYNTAX ERROR: AS  '&|#8240 
. I don't know why but something in my head said: try this without the semicolon. And wonder, wonder it worked.

Any ideas how this is possible? As this is handeld by the browser I don't think this has something to do with my WF version, could it?

ps we will test WF 7.6.11 shortly.

This message has been edited. Last edited by: <JJI>,
April 06, 2010, 08:07 AM
JACQUETL
have someone there a idea for pdf format ?

Thanks


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
April 06, 2010, 06:25 PM
Dan Satchell
This seems to work:

-SET &PERMILLE = HEXBYT(137,'A1');
-*
TABLE FILE CAR
 SUM COMPUTE PCT.SALES
 COMPUTE TSALES/D12.2 = PCT.SALES/10; AS '&PERMILLE'
 BY COUNTRY
 ON TABLE PCHOLD FORMAT PDF
END



WebFOCUS 7.7.05
April 07, 2010, 02:36 AM
JACQUETL
Ho great Dan !

Good One

thanks


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH