You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to filter on the startdate of first event if a person may have multiple events attended?

Accepted answer
1
Views
2
Comments

Summary:

Report on only the first event

Content (required):

I need to have a report which only displays the first event to which a person has been. So I have the contacts table and a custom Event table. The relationship is one to many, one person can attend multiple events. But I only want to display the StartDate of the first event attended.

I am unsure what I need. I used a group filter to only count one record but that didn't work out. Also the min(Event.StartDate) in a column didn't work out. Do I need a custom script or can I do this with a filtered outerjoin or any other idea?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!