Display Superscript in SSRS reports

Question

I m working on SSRS 2008. i want to display date as 1^st January 2011.. but "st" should be in superscipt .. not like "1st".

is there any way to display "st", "nd","rd" and "th" in superscipt without installing any custom font type(other Font Type).

score 40 · Answer 1 · edited Aug 22 '19 at 05:54

40

just copy and paste from the following list:

ABC⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾ ABC₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎

ABCᵃ ᵇ ᶜ ᵈ ᵉ ᶠ ᵍ ʰ ⁱ ʲ ᵏ ˡ ᵐ ⁿ ᵒ ᵖ ʳ ˢ ᵗ ᵘ ᵛ ʷ ˣ ʸ ᶻ

ABCᴬ ᴮ ᴰ ᴱ ᴳ ᴴ ᴵ ᴶ ᴷ ᴸ ᴹ ᴺ ᴼ ᴾ ᴿ ᵀ ᵁ ᵂ

ABCₐ ₑ ᵢ ₒ ᵣ ᵤ ᵥ ₓ

ABC½ ¼ ¾ ⅓ ⅔ ⅕ ⅖ ⅗ ⅘ ⅙ ⅚ ⅛ ⅜ ⅝ ⅞ № ℠ ™ © ®

ABC^ ± ¶

edited Aug 22 '19 at 05:54

S. Mayol

2,565
2
27
34

answered Feb 11 '16 at 22:11

Mohammad Baygi

604
1
7
13

1

is there a reason for no superscript for capitalized C,F,S...? – Haijin Dec 18 '19 at 18:48
how did you format them? i can't seem to mimic it, I need to put [1][1] and [x][x] into the same super scripted text. – Elizabeth Jun 07 '23 at 15:39

score 4 · Answer 2 · answered Jun 13 '11 at 12:47

4

Maybe...

You are limited to what can be done with String.Format. Font size and spacing also refer to the whole text box. So it isn't "native"

However, superscript is unicode so you may be able to to do it with some fancy expression that concatenate characters. I'd suggest custom code.

I haven't tried this, but these articles mention it

answered Jun 13 '11 at 12:47

gbn

422,506
82
585
676

3

In 2008, you can set the placeholder format to HTML and use certain HTML tags in your formatting (e.g. `="Some bold text"` works); I don't know if that includes `^{`, or maybe a `` you could style, though, as I'm only on 2005.} – Matt Gibson Jun 13 '11 at 12:53
Guyz .. it works for 0-9 only ... i need "st" , "th", "nd" .. i know that superscripts.... i need to know about words that i mentioned .. i dont need 0-9 or n as superscript .. – Touseef Jun 13 '11 at 13:11
1

@Touseef: then no, you can't do this – gbn Jun 13 '11 at 19:10

score 1 · Answer 3 · answered Nov 29 '19 at 06:48

I am not looking for credit here as above solution has answered it for you but for beginners sake, I use a code function within my report.

So in my SQL say I have Number field, then I add a new field OrdinalNumber:

SELECT ..., Number, 
       CASE WHEN (Number % 100) BETWEEN 10 AND 20 THEN 4
            WHEN (Number % 10) = 1 THEN 1
            WHEN (Number % 10) = 2 THEN 2
            WHEN (Number % 10) = 3 THEN 3
            ELSE 4 END AS OrdinalNumber,
...

Then my code function:

Function OrdinalText(ByVal OrdinalNumber As Integer) As String
    Dim result As String
    Select Case OrdinalNumber
        Case 1
            result = "ˢᵗ"
        Case 2
            result = "ⁿᵈ"
        Case 3
            result = "ʳᵈ"
        Case Else
            result = "ᵗʰ"
    End Select
Return result

End Function

Then in the report textbox I use the expression:

=CStr(Fields!Number.Value) & Code.OrdinalText(Fields!OrdinalNumber.Value)

Display Superscript in SSRS reports

3 Answers3