Reports - Calendar Events

A report based on the top level Calendar Events table lets you, not surprisingly, report on any calendar event in the system.

For cases:

• Case Data > Associated Calendar Events has all the detail. It produces one row per event.
• Case Data > Most Recent Calendar Event has several fields about, you guessed it, the most recent event on a case. This includes future events.

Events can have multiple attendees:

• Use the Attendee (One Line per Attendee) > Attendee [Full Name] > Attendee Name field to get what it sounds like. A filter on that field is a nice list of names.
• If you want all the attendees joined in one cell, set a Text Join aggregate on that column, and if you are filtering on it, set the Apply after Aggregate option in the filter..
• There is also an Attendees (List All per Event) > All Attendees field that will display all the attendees in one cell, no aggregation needed, but it presents a text style filter that people find hard to use.