Number sorting 2

[buckslor]

Hi all

I'm trying to sort numbers in crystal report xi but having problems getting it to sort correctly. I have aisle numbered from 1 - 300. For example, I need to sort aisle 5, 54, 80, 128 and 208.

It should sort the records like this
5
54
80
128
208

but instead it's sorting it like this
128
208
5
54
80

Is there a formula to use to add 2 zero's to a single digit number to have aisle 5 display as "005" and add a zero to 2 digit aisle to have aisle 54 display as "054"? that may help with the sorting.

Any point in the right direction would be appreciated.

Kind Regards

 

[TeyBrady]

You answered your own question.


Right("000" + aisle, 3)

 

[lbass]

Use a formula like this for sorting purposes only:

totext(val({table.aisle}),"000")

You can add the original field to the report though.

-LB

 

[buckslor]

Thanks TeyBrady and lbass - both formulas work great. I just couldn't figure out how to do it.

Many thanks