Correcting group sort order??

[JoshAdvantix]

I have invested unbelievable newbie hours into Crystal and am hitting one final snag in a report I need to complete.

There are three fields in play (PhoneNumber, GroupName, GroupValue). The query returns a row for each phone number/groupname/group value... i.e.

555-1212 Location San Antonio
555-1313 Location Dallas
555-1414 Location Austin
555-1212 Department Service
555-1313 Department Service
555-1414 Department Service

This is how the information is coming out of the grouping that I have set up:

Group#1: Location
PhoneNumber GroupName GroupValue
555-1212 Location San Antonio
555-1313 Location Dallas
555-1414 Location Austin
Group#1: Department
Phone Number GroupName GroupValue
555-1212 Department Service
555-1313 Department Service
555-1414 Department Service

I need it to come out like this:

Group#1: Location (San Antonio)
Phone Number GroupName GroupValue
555-1212 Department Service
Group#1: Location (Dallas)
Phone Number GroupName GroupValue
555-1313 Department Service
Group#1: Location (Austin)
Phone Number GroupName GroupValue
555-1414 Department Service


Your help would be tremendously appreciated!!!

 

[JoshAdvantix]

Crystal XI