Wednesday 29 January 2014

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:
Superscript and subscript codes


How to find a  character code (Numeric value) of a character:
  1. Open Microsoft Word
  2. Insert Menu-->Symbols-->
  3. Change the Font to Lucida Sans Unicode 
  4. Scroll down and find the superscript value of a character
  5. 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:

At 15 April 2014 at 22:24 , Blogger Unknown said...

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