3 Replies Latest reply on Oct 17, 2012 12:05 PM by brian.curran

    Reporting on a missing value in a Join Table

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