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

You'll need to create a formula for each event.

IF {Event} = "Museum Trip" THEN {Response} ELSE "" 

You will also need to create a group on each participant (or constituent).  Since it appears that you don't have the sortkey on the file, you'll probably want to create one.

In the group header (or footer) for the participant, you'll need to find the maximum for each of your event formulas.

You'll probably want to suppress the details.

The Notes may be more problematic, because it's not clear if this is a note that is coming from a constituent type record or from a participant type record.  In the first case, the note will be exactly the same on each of the person's events, in the second, it's possible that you may have different notes for different events.

In the first case, you can create a separate formula for the Notes, but you don't need to.  Since all of the notes will be the same, you can just place the Note field in the header/footer and it will display the first/last note.

In the second case, you'll probably have to use a sub-report.

Drew