Answers.Body: <p>I had a client with a similar issue.  They resolved it by not adding a facilitator to any events they didn't facilitate.</p>
  
  <p>Assuming that's not a workable workaround for you - it IS possible to generate reports like you're describing, but you'd need to either a) code it (or find someone to code it), or b) use an (often pricey) third-party reporting tool.  Come join us at <a href="https://chat.civicrm.org" rel="nofollow noreferrer">https://chat.civicrm.org</a> if you'd like to discuss custom reporting options - either doing it yourself or finding someone to do them.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-18T13:49:14.620Z
Answers.Text: I figured I'd have to build something, but as I've not gotten into coding new reports and have a slightly shaky grasp of the MySQL side of things, I didn't want to start digging into that process only to find that it wasn't possible at all - if it's at least theoretically possible, I'll bring it to the chat site to see if I can get some pointers.
Answers.UserDisplayName: liblogger
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-18T13:55:12.977Z
Answers.Text: Re: your first point - it's unlikely that our facilitators won't also be attendees of other events, but if it was, I don't see how I get information about the other attendees of events they're facilitating (I can get all the events they facilitate, but then have to go into each event to collect information about event participants)
Answers.UserDisplayName: liblogger
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-18T15:34:31.027Z
Answers.Text: You're right - I'm misremembering.  I've since moved companies, so I can't look at my old notes to see how it was resolved.  Sorry!
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-19T15:41:37.197Z
Answers.Text: No problem - I'll raise it in the chat site when I get a chance
Answers.UserDisplayName: liblogger
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-17T14:33:37.877Z
Answers.LastActivityDate: 2017-04-17T14:33:37.877Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>Currently if I want to collate a report on events facilitated by a particular individual (or, say, run by a partner organisation, or any contact with a custom role), I have to go to each event from their contact record, or add each event title to the event 'is one of' filter - it's not possible to filter the event participant list report by a facilitator without limiting the data to that facilitator, and the other event reports (e.g. event summary) can't be filtered by an individual. </p>
  
  <p>Is it possible to build a report to filter in this way? i.e. for a list of events filtered by one contact record, provide data on all event participants.</p>
  
  <p>(I had considered just adding the facilitator as a custom contact reference field, but unfortunately that only allows me to add one contact per field, and there's sometimes more than one facilitator per event.)</p>
  
Tags: <civievent><civireport>
Title: Filter event reports by facilitator
ThreadText: # Filter event reports by facilitator
  
  (Asked by: username_0 on 2017-04-17)
  
  Currently if I want to collate a report on events facilitated by a particular individual (or, say, run by a partner organisation, or any contact with a custom role), I have to go to each event from their contact record, or add each event title to the event 'is one of' filter - it's not possible to filter the event participant list report by a facilitator without limiting the data to that facilitator, and the other event reports (e.g. event summary) can't be filtered by an individual.
  
  Is it possible to build a report to filter in this way? i.e. for a list of events filtered by one contact record, provide data on all event participants.
  
  (I had considered just adding the facilitator as a custom contact reference field, but unfortunately that only allows me to add one contact per field, and there's sometimes more than one facilitator per event.)
  
  **Tags:** civievent, civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-04-17. Score: 0
  
  I had a client with a similar issue. They resolved it by not adding a facilitator to any events they didn't facilitate.
  
  Assuming that's not a workable workaround for you - it IS possible to generate reports like you're describing, but you'd need to either a) code it (or find someone to code it), or b) use an (often pricey) third-party reporting tool. Come join us at <https://chat.civicrm.org> if you'd like to discuss custom reporting options - either doing it yourself or finding someone to do them.
  
  > **Comments:**
  > **username_0**: I figured I'd have to build something, but as I've not gotten into coding new reports and have a slightly shaky grasp of the MySQL side of things, I didn't want to start digging into that process only to find that it wasn't possible at all - if it's at least theoretically possible, I'll bring it to the chat site to see if I can get some pointers.  
  > **username_0**: Re: your first point - it's unlikely that our facilitators won't also be attendees of other events, but if it was, I don't see how I get information about the other attendees of events they're facilitating (I can get all the events they facilitate, but then have to go into each event to collect information about event participants)  
  > **username_1**: You're right - I'm misremembering.  I've since moved companies, so I can't look at my old notes to see how it was resolved.  Sorry!  
  > **username_0**: No problem - I'll raise it in the chat site when I get a chance  
  
  ---
  
  