Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping and Sorting by field

Status
Not open for further replies.

aimbc

IS-IT--Management
Joined
Apr 18, 2001
Messages
47
Location
US
I am trying to sort within a group by a specific field.

I am grouping by PersonID(Group1) but, would like to sort by PersonLastName and PersonFirstName within PersonID(Group1).

How can I do this? I tried following the help instruction but it still does not work. Its only sorting by Group.

I am running the version 7.0.1.100

Any help would be appriciated. Thanks.[sadeyes]

Brian
 
Grouping puts the records in order, and takes priority over the group. So if you group by personID you will get one person in each group. There will be nothing left to sort. I would write a formula that is:

{Last name} + ', ' + {First Name}

And group on that formula Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Sorry, I meant to say that grouping puts the records in order, and takes priority over the SORT. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top