Sorting on Numerical Values

[PhilipSt]

I have several reports where I want to sort a column by its numerical value. The native sort facility is alphabetic. This is OK if the numbers do not go above 9. Once I get into double-figures, it's a mess =( Does anyone know of a fix for this...? Thanks, Phil

[MartyGa]

Phil - It sounds like you're storing the number as a text field? You may want to try using a custom column on the report then (yes, text mode) using valueexpression=NUMBER({MyFieldName}) to convert the string to a number, then you should be able sort as needed.

[PhilipSt]

@Marty.... Thanks! that worked perfectly =D