Group by one field, sort by another field 1

[lesleycampbell]

I have a report that groups by the employee ID. I need the records returned to be in alphabetical order based on the employee name field. Help?

 

[pmax9999]

Hi Lesley

Create a formula that concatenates the ID and Name fields, something like:

{Table.Employee_LastName} + '/' + {Table.Employee_FirstName} + '/' + {Table.Employee_ID}

The inclusion of the ID field ensures unique groups even if two or more employees have the same First and Last names

Change the grouping to use this new formula, suppress/remove the Group Name and replace it with the Name fields.

Hope this helps

Cheers
Pete

 

[Charliy]

Always include a delimiter in concatenated fields, like the slash in Pete's example.

Without delimiter ADAMSONJACK comes before ADAMSMICHEAL.

With the delimiter ADAMS/MICHAEL is before ADAMSON/JACK

 

[Charliy]

Oops, too early in the morning. For that example to make sense Micheal should be Tom.

 

[lesleycampbell]

Thank you, both!! It worked!

 

[pmax9999]

Charily

I adopted the use of delimiters after seeing one of your previous posts. I had not been caught out by circumstances you describe but it certainly could happen so is worth being prepared for. Have a star!!

Pete.