AnsweredAssumed Answered

Reporting on a missing value in a Join Table

Question asked by brian.curran on Oct 17, 2012
Latest reply on Oct 17, 2012 by brian.curran

Title

Reporting on a missing value in a Join Table

Post

     Hi,
     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"

     E.g.
     Site A     Key Holder
     Site B     Key Holder
     Site C

     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 :)

Outcomes