Sorting/Reporting Value Lists in Portals

[fiona]

I have a portal in my sales database for event registration (date, event, qty, payment info, etc.) The events field is a value list, drop-down menu with many choices. This is related to my contacts database. (One contact may register for many different events).

First, I want to be able to find everyone who's registered for a specific event (ie "farm tour"). Pretty stright forward through find...

Next, I want to list all of these participants in a report by last name. Again, pretty easy...

The catch is, I can generate all of this, but end up reporting the first entry from each portal (which is not always "farm tour").

How do I get all of the "farm tour" participants from any portal row to show up - first in my sort and then second in my report?

Is that clear? Can I even do this? Thanks for the help.

[Fitch]

Do your report from the related table.