Groups | Blog | Home
all groups > sql server reporting services > october 2007 >

sql server reporting services : bottom to top formating



michael vardinghus
10/6/2007 12:05:02 AM
hi

i had luck formatering a text box top to botto in formatting:

t
e
s
t
i
n
g

but i would like bottom to top and i cant seem to find it

g
n
i
t
s
e
t

any ideas ?

EMartinez
10/7/2007 5:32:22 PM
[quoted text, click to view]


You might be able to use the StrReplace function (i.e., an expression
like):
=StrReplace(Fields!SomeField.Value)
If this doesn't work, you may need to create a single-column table
control and populate it from a dataset that is custom sorted before
getting to the report (in the stored procedure/query that sources the
report).
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant
Jason
10/8/2007 4:32:20 PM
[quoted text, click to view]

I think you might mean the StrRev() function. (String Reverse)
Because essentially, the formatting is correct, you just want the
letters to appear in reverse order.

- Jason
Jason
10/8/2007 4:36:51 PM
[quoted text, click to view]

Whoops, sorry I got the function name wrong too. Must be contagious.
It is actually StrReverse
(strrev is correct for PHP, not VBScript. I deal with too many
languages)
Or if you want you can also reverse it in the SQL query if you don't
want to do an expression with the T-SQL REVERSE function.
- Jason
EMartinez
10/9/2007 12:21:43 AM
[quoted text, click to view]


Oops, sorry about that, that's what I meant. Thanks for catching that
Jason.

Regards,

Enrique Martinez
Sr. Software Consultant
AddThis Social Bookmark Button