create custom concatentation or embedded grouping

[ry1633]

Hi all

I have a table that has an ID and Employee ID column.   The ID column is unique, but can have multiple Employee IDs associated with.   And the Employee ID relates to an Employee table that has the First Name, Last Name info it etc.

I need to build a a single Cognos query item with a concatenated list of all employees for each ID, separated by a semi-colon. Basically like an embedded grouping. So the output would look something like this:

ID:
100000

Employees:
LastName1, FirstName1; Last2, First2