Solved

Order a group aphabetically

Posted on 2014-02-22
5
280 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
5 Comments
 
LVL 142

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 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 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 34

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now