Hi
I can find a list of multiple events attached to a single individual no problem, however when I reverse this and try and list the individual (and others like them) as attending multiple events I can't get it to work.
What I want is a report which, in simple terms, says.....
Give me all the contacts who have attended both event A and event B. The list should not contain people who have attended only one of them.
Thanks
Graham
*This post is locked for comments
I have the same question (0)
If you are creating an SSRS report, you can link more than one entity of the same type to the contact entity, in which case you could say something like this:
entity name=contact
link-entity event
condition type="a"
link-entity event
condition type="b"
Of, if it's N:N, you might link N:N to the contacts(twice), and, then, events to those N:Ns
However, you can't do that in the Advanced Find. If you want this to work in the Advanced Find, try creating two rollup fields on the contact entity and see if you can calculate the number of A and B events which the contact has attended. Then display those contacts where both fields values are greater than 0. This would require a 1:N relationship, though
Share
Report
All responses (
Answers (
34,477
