[SOLVED] How to display special charcters on report
I have a special charcter, its a legal section character (§§) that I need to get onto my report without it changing to question marks as an output. The Hex code for the character is A7. Can anyone help me with this?This message has been edited. Last edited by: <Kathryn Henning>,
WebFocus 7.6.11 Linux Excel, PDF, HTML
August 15, 2014, 04:20 PM
eric.woerle
I think the function you are looking for is HEXBYT. You can find more information on it in the help file. I don't know if that specific value is in there, but you can check. theres a link to a list of characters. Also I believe this will depend on you NLS settings and the type font you are using as well. The character would need to be supported by each of those too.
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
August 18, 2014, 01:23 AM
Rifaz
Hi Nguyet,
Welcome to the forum!!!
After setting the code page value is 1252 in Reporting Server Console, believe, you'll be able to see §
-SET &char=HEXBYT(167,'A1');
-TYPE &char
-Rifaz
WebFOCUS 7.7.x and 8.x
August 18, 2014, 04:15 PM
susannah
the section symbol is & # 1 6 7 = § or & s e c t = § here's a reference http://www.ascii.cl/htmlcodes.htm and you can use them in your fex, remembering to use the escape character for the ampersand &|#167; or &|sect;
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 18, 2014, 08:07 PM
Alan B
As long as you use the correct code pages in WebFOCUS this character will be visible in all outputs. Use 137 not 437 on the server and 137 on the client.
Alan. WF 7.705/8.007
August 22, 2014, 11:08 AM
Nguyet
quote:
&|#167
Thank you all for your suggestions. I did use &|#167 and it worked out perfectly.
