Solved

Crystal Report sort on something other than the group

Posted on 2012-03-19
1
272 Views
Last Modified: 2012-03-20
I group on an ID how do I sort on the name in the same table?
0
Comment
Question by:trinisunset
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 37740544
When you group on a field, Crystal automatically uses that field for a sort.

You could group on the NAME then group on the ID to take care of duplicate names.

Another way that would work is to add a summary on the name field.
I assume the ID has only 1 name.
Right click the NAME field
Click INSERT --> SUMMARY
Choose MAXIMUM
Put the summary in the group footer
Click OK
Drag the summary to the group header
Click REPORT --> GROUP SORT EXPERT
In the FOR THIS GROUP SORT set the dropdown to ALL
Select the MAXIMUM summary from the other block

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

895 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

17 Experts available now in Live!

Get 1:1 Help Now