2 Replies Latest reply on Feb 14, 2017 2:12 AM by Ivar Arnarsson

    Suppress nulls in hierarchy...

    Greg von dem Bach

      Hi Everyone,

       

      I was able to create an org chart hierarchy from a self-referencing database table and it is working great.  The only thing I can't seem to figure out is how to suppress nulls from showing up on lower levels as I traverse the hierarchy.

       

      For example:

      Person A reports to Person B who reports to Person C who to Person Z

      Person D reports directly to Person Z

       

      The data in the table I created:

      Person A Record:  Level 1 = Person Z, Level 2 = Person C, Level 3 = Person B, Level 4 = Person A

      Person D Record:  Level 1 = Person Z, Level 2 = Person D

       

      When I expand the hierarchy to Level 2 I correctly get:

      Person Z

      Person C

      Person D

      But when I expand the hierarchy to Level 3 I start getting nulls padded below Person D:

      Person Z

      Person C

      Person B

      Person D

      <null>

      Expanding to even lower levels of the hierarchy replicates the <null> values downward:

      Person Z

      Person C

      Person B

      Person A

      Person D

      <null>

      <null>

       

      Is there a way to suppress null values for levels of the hierarchy where no value exists?  I tried excluding nulls using a filter but that eliminates all rows that contain a null.  So in the above example the Person Z/Person D hierarchy wouldn't display at all as the null on Level 3 filters the entire row.