?
Solved

Order a group aphabetically

Posted on 2014-02-22
5
Medium Priority
?
308 Views
Last Modified: 2014-02-23
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?
0
Comment
Question by:Stevepaget
  • 2
4 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 39880513
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
 

Author Comment

by:Stevepaget
ID: 39880521
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
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 39880532
you should be able to configure that "sorting" in the crystal report easily, by setting so the grouping and ordering screen.
0
 
LVL 35

Expert Comment

by:James0628
ID: 39880899
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you are like me and like multiple layers of protection, read on!
Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question