Forcing a sort 2

[RiverGuy]

A have a question for you Crystal experts out there. What would be the best way to force a sort order? I have a group sort, but it does not make sense to sort alphabetically. The field text is a formula field. But it does not make sense to group it alphabetically because it has to do with numbers. So basically I would like to define my out sort order.

Is this possible?

Thanks.

 

[synapsevampire]

Create a formula based on the numeric equivalent of the field and use this to group/sort.

val({MyTable.MyField})

You can then display the database field, and it will be sorted numerically, but showing the alpha version in case you have leading zeroes in the database.

Hence:

1
12
101
2

will group and sort as:

1
2
12
101

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

With groups you can also use the 'specified order' feature instead of ascending. This lets you decide the order of each item. 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

 

[RiverGuy]

OK. I will try the 'specified order'. I can't do the numeric equivalent because there is text in the fiels too. For example 'Between', or 'Less than'