Sorting

[ghostofelmo]

I am sorting my reports by priority. We are using a range of 1-10, how do I get the 10 to print after the 9, instead of the 1?

 

[Kendel]

Your range is a string data type, you need to create a formula and use ToNumber() to convert it to numeric. And then sort by this new formula.

 

[ghostofelmo]

Formula returned not a numeric value. But I discovered that you can sort by "speicfied order" and just typed 1 through 10 and it worked

 

[Madawc]

You could also add a leading zero, e.g.

if Length({your.field}) = 1 
then "0" & {your.field} 
else {your.field}

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10