I have a report (CR 188.8.131.52) printing out details of multiple people living at street addresses. Group 2 is the street. Group 3 is the address formula consists of four data fields: number; letter suffix; half; unit. i.e. 97A Main St or 125 Washington Ave Unit 17. I need the order of Group 3 to have numeric priority (1, 5, 14-A, 33, 275, 4200) rather than alphanumeric (1, 14-A, 275, 33, 4200, 5).
I have tried ordering by fields using the ORDER clause in Show SQL Query. This seems to do nothing. I have tried the various options in Change Group Options. These mostly deal with the formula as alphanumeric. Record Sort Order will not allow me to remove or reorder groups.
How can I order these street addresses in numeric (street) order?