Grouping data in Report

[Leelers]

I have a table of data for subjects in a research study. There have been 5 rounds of data collection, so every subject has 5 rounds of data (phone numbers, etc). I need to generate a report that shows the subjects name and ID number, and then every phone number that has been recorded for them in every wave. But so far all I can manage to do is generate lengthy and repetitive reports in which I get the subject's name, ID, phone numbers in five separate groups.

So my data looks like this:
ID Name Phone
1 Smith 3334445555
1 Smith 3334445555
1 Smith 3334447777
2 Jones 3334445556
2 Jones 3334448888

And I need a report that says:

ID: 1
Name: Smith
Phone: 3334445555
3334447777

ID: 2
Name: Jones
Phone: 3334445556
3334448888




But instead I can only generate reports that look like this:

Id: 1
Name: Smith
Phone: 3334445555

Id: 1
Name: Smith
Phone: 3334445555

Id: 1
Name: Smith
Phone: 3334447777

And so on. Little help?

[thhui]

Create a temporay table first,
so that the 2nd telephone number becomes the first one's extra field.

Then, you can generate the report easily.