I have what I hope is an easy question for someone.  I need to sort my data by last_name, then first_name.  I tried concatenating the two fields (last_name & first_name) but this does not work too well with last names that are very similar.  I currently have this code in place in a formula field, which I then have set up as a group:

 

 

I tried to add the first_name field to the above statement but did not get the correct results.

 

Is there a way to modify this statement to include the first name as a secondary sort?

 

Thanks!

Frank

 

Once again, thanks for your help with Crystal Reports.  Have a great week!

 

Frank