开发者

Display Superscript in SSRS reports

I m working on SSRS 2008. i want to display date as 1st开发者_运维知识库 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).


just copy and paste from the following list:

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

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

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

ABCₐ ₑ ᵢ ₒ ᵣ ᵤ ᵥ ₓ

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

ABC^ ± ¶


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

  • http://beyondrelational.com/blogs/jason/archive/2010/12/06/subscripts-and-superscripts-in-ssrs-reports.aspx
  • http://www.codeproject.com/KB/reporting-services/SSRSSuperscript.aspx


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)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜