I have an issue with sorting records alpha numerically in Crystal. I'm not sure it's Crystal as much as the way we have coded our back end MSSQL database.
We have reference numbers which are like this:
AA12 - and so on...
What is happening in sorting my records is this:
AA4 and so on...
Is there a way to sort these in proper alpha numerical order even if a formula has to be used? It's creating a nightmare with my reports.
Any help would be much appreciated.