SSRS: Superscript and Subscript text to display
It seems you want to display more and more Unicode chars in the Report. If I have misunderstood, please let me know.
By default, the function “chr()” only display the ASCII code. The ASCII code only has 255 codes.
To display Unicode chars, we could use the function “chrW()”.
E.g.
Superscript 9: =chrW(8313)
Subscript 9: =chrW(8329)
If the Reporting Services can’t not display Unicode characters, please follow these steps to solve the issue:
1. Goto Control panel -> Regional and Language option -> Language tab .
2. Click on Install files for complex scripts and right to left languages.
3. It will prompt a message box, You have to insert the operating system CD to get it installed.
Here is a document refers to Unicode chars:
http://unicode.org/charts/PDF/U2070.pdf
Superscript and Subscript Value of 0 to 9:
How to find a character code (Numeric value) of a character:
- Open Microsoft Word
- Insert Menu-->Symbols-->
- Change the Font to Lucida Sans Unicode
- Scroll down and find the superscript value of a character
- Say for example superscript value of 9 is 8313 so in the SSRS expression you will type= chrW(8313)
Note from someone:
t is font specific - BUT - be careful what versions of fonts you have. Newer operating systems have newer fonts. For example, I got the superscript to work on my dev box that is running windows 7, but it produced only squares when I published to a web server running server 2003.
When I copied over the fonts from my Win 7 box to the Win 2003 server, it worked.
Ultimately we decided not to use the superscripts on the chart title because deploying to other environments over which we have no control could mean that the superscripts would not appear properly.
1 Comments:
Hi Masud,
Thanks for posting... This is really most effective and informative blog on SSRS. I like to collect these types of data. Worries like security of data can be evaded with the help of SSRS. This is because, it ensures that a role-based safety model is adapted, so that the data source is protected. It is designed such that the employee of the organization has access to data. If you can see how the use of the software can protect data following the industry standard,then contact here:
Email: Info@ForerunnerSW.com
Website: www.forerunnersw.com
Post a Comment
Subscribe to Post Comments [Atom]
<< Home