Reporting on a missing value in a Join Table
I want to create a report that displays a list of all Site names that don't have a certain Role type defined in a Join table. I currently have the following:
People --> JoinPeopleSite <-- Site
In the Join table, I have a 'Role' text field which is defined as a Checkbox set on the Layout. One of the values I want to report on is the term "Key Holder"
Site A Key Holder
Site B Key Holder
In the above scenario, the report would only list Site C
I've tried using a portal without success and now trying to accomplish this in a List view. Any help would be appreciated :)