?
Solved

Crystal Report sort on something other than the group

Posted on 2012-03-19
1
Medium Priority
?
309 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 101

Accepted Solution

by:
mlmcc earned 2000 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

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…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…
Suggested Courses

589 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