Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

Crystal Report sort on something other than the group

I group on an ID how do I sort on the name in the same table?
0
trinisunset
Asked:
trinisunset
1 Solution
 
mlmccCommented:
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now