title: Crystal Reports Order By logic switch to asc then desc
body: <p>I have a crystal report that contains a location column. I can sort the order by the location column using the Record Sort expert and set as Ascending Order.</p>
  
  <p>However.. the locations now have to not only follow alphabetical order they will have to loop back to highest number when the first or second letters change.</p>
  
  <p>For example:</p>
  
  <p>Locations: AA1, AA2, AA3, BA1, BA2, BA3</p>
  
  <p>To appear in order as</p>
  
  <p>AA1</p>
  
  <p>AA2</p>
  
  <p>AA3</p>
  
  <p>BA3</p>
  
  <p>BA2</p>
  
  <p>BA1</p>
  
  <p>Is that possible? Would I need to use multiple case statements? I would be grateful for any help.</p>
  
  <p>Thanks,</p>