When I try and sort the items in a group in sql it does not work. It seems the order by "in ascending order" that Crystal requires to set in the IDE is not over ridden in an SQL query.

Would anyone know how I can modify the way results are sorted in code when using a group?