How do you sort this?

[stormtrooper]

When I do a sort on a field this is what I get:
1, 10, 11, 12, 13, 14, 15, 2, 3, 4, 5, 6, etc.

What I want is:
1, 2, 3, 4, 5, 6, 10, 11, 12, 13, 14, etc.

 

[MalcolmW]

Create a formula that converts your field from text to numeric, and then sort on that formula field. Malcolm Wynden
Authorized Crystal Engineer

http://www.wynden.net

malcolm@wynden.net

 

[Ngolem]

an alternative to Malcolm's approach would be to pad the variable with spaces....Pick the maximum size of the number (say 5 digits)...then you can do this for a sorting formula or group on it for that matter

@SortVariable

spaces(5 - length({table.strValue))) + {table.strValue}



Jim
JimBroadbent@Hotmail.com

 

[kenhamady]

The easiest way is to write a formula that is:

Val({your.field}) and sort on that. You dont have to show the formula, just sort on it. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[MalcolmW]

Oh, come on, the easiest way is to store numbers as numbers in the database in the first place Malcolm Wynden
Authorized Crystal Engineer

http://www.wynden.net

malcolm@wynden.net