Hi All,

I've noticed that having dashes in an alphanumeric sort field causes the data not to be sorted correctly:


A simple Crystal formula highlights the issue:

StrCmp ("A-B","AAA") returns 1, i.e. "A-B" is greater than "AAA", but
StrCmp ("A-A","AAA") returns -1, i.e. "A-A" is less than "AAA".

I know I can work around this by manipulating the data but with hundreds of reports containing multiple groups and sort values this is not practical. Is there some setting or collating sequence I need to set? Why is it doing this?

I'm running CR XI R1 SP3 on Windows Vista. I also get the same result in CR 8.5.