none
Changing the alignment of text box RRS feed

  • Question

  • Im using SSRS 2005

    I have a text Box which contains the day of the week, e.g. Monday

    I would like this displayed like this

    Y
    A
    D
    N
    O
    M

    But the words the other way, if you know what i mean!

    Thanks
    Monday, March 15, 2010 10:25 AM

Answers

  • Hi Sam,

    You can do it with writing your own function. Do following:-

    in report properties, go to code tab and add following code

    function MyString(byval s as string) as string
    dim x as string
    dim a as char
    
    x = ""
    
    
    for each a in strreverse(s)
    x=x & a & vbcrlf
    next
    
    return x
    end function
    and where you want string to put in the report, call it like this

    =code.MyString(fields!Name.Value)

    hope it will serve your purpose
    mark it as answer if it answered your question :)
    • Marked as answer by Sam233 Monday, March 15, 2010 2:58 PM
    Monday, March 15, 2010 2:40 PM