Groups | Blog | Home
all groups > sql server reporting services > april 2005 >

sql server reporting services : Convert string to numeric


Chris Patten
4/8/2005 12:57:02 PM
I have a field which in the db is is char, and I want to sort in the report
numerically. Tried changing it in many areas but it still sorts as if alpha.
Is there an expression I can use on the report field to convert it to
numeric? Will cast or convert work in a field level experssion?

Suneet
4/8/2005 1:55:03 PM
Edit Field and make it like Cint(Fields!MyField.Value)
Then sort on this field.


- Suneet Mohan

[quoted text, click to view]
AddThis Social Bookmark Button