Order a group aphabetically

I have a customer table and a kits table in the database. Both table contain an ID which is a long string field ie 94f1a065-1169-4e02-ba2e-071a52e5ba45. Thes tables also contain a description.

I want to group by the ID but then order alphabetically on the description. How would I do this?
StevepagetAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you should be able to configure that "sorting" in the crystal report easily, by setting so the grouping and ordering screen.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you please explain a bit more details on which table's ID and which table's description you want to "group" and "order". note that "grouping" and "ordering" is sometime "misused" in terms of communication vs technical syntax.
0
 
StevepagetAuthor Commented:
I group by the ID because the description may be the same. Every Kit/customer has a different ID even though the description maybe the same or very similar.

However I then want to order the list in alphabetical order based on the description
0
 
James0628Commented:
FWIW, another option would be to group by the description, and then the ID.  The report would be grouped, and sorted, first by the description, and then if you had two ID's with the same description, they'd be grouped separately by the ID.  You could suppress the description group header and footer, so you could only see the ID group.

 James
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.