Skip to Content
0
Former Member
Apr 29, 2009 at 02:29 AM

Sort string in certain order in Crystal XI

36 Views

Hi All

I have a report that lists all of our fleet in 'facilitycode' order. Like this;

101

1000

1001

110

1112

1113

111, etc.

The field is a string and I have found how to sort this through converting to a number. My problem is one facility code is '269.B'. I can't find a way to display in numerical order AND make allowances for letters. We will be encountering this problem a lot more and I want to get it sorted before end users launch an attack.

Appreciate any suggestions

duffey01