I have a report that pulls product data based on a heirarchy system (4 levels). One of the criteria for the report is to exclude any recrods that are missing any piece of the hierarchy.
For example...Level 3 is null but levels 1, 2, & 4 are filled in or Levels 2 & 4 are filled in but Levels 1 & 3 are null. Those records need to be excluded from the report but any record that has all 4 Levels filled in needs to be included.
My first reaction is to use the report filter but I can't seem to get exactly what I'm looking for so I was wondering if there was an easier way to accomplish this?
Travis
For example...Level 3 is null but levels 1, 2, & 4 are filled in or Levels 2 & 4 are filled in but Levels 1 & 3 are null. Those records need to be excluded from the report but any record that has all 4 Levels filled in needs to be included.
My first reaction is to use the report filter but I can't seem to get exactly what I'm looking for so I was wondering if there was an easier way to accomplish this?
Travis