Novice with an urgent problem

[denerious]

Hello,
I have flat file which comes from a database however some of the information is exported incorrectly. I need to find a solution as this is a major problem that I didn't know the d/b had issues with.
I have been informed Crystal Reports can solve this.
When I export the information it comes as

Unique ID - Surname - Firstname - Event - Response - Notes
52 - Bloggs - Joe - Museum Trip - Attending - Diabetic
52 - Bloggs - Joe - Zoo Trip - Attending - Diabetic
etc

However I need the information to display as

Unique ID - Surname - Firstname - Museum Trip - Zoo Trip - Notes
52 - Bloggs - Joe - Attending - Attending - Diabetic
56 - Smith - John - Attending -Unable to attend

(I have added "-" above just to show the seperation of data.
Any help would really be appreciated

kind regards

Michael

[DavidCh]

Well, this comes to mind.

You could group by unique id. in the details section you would have:

52 - Bloggs - Joe - Museum Trip - Attending - Diabetic
52 - Bloggs - Joe - Zoo Trip - Attending - Diabetic

However, in the group footer you could create a custom formula which would give you:

52 - Bloggs - Joe - Attending - Attending - Diabetic

The whole " Attending - Attending" section would be a custom formula concantenating the trip fields into one string and then would present it that way.

Does that help?

Dave