Hi,
I'm using CR 2008 version 12.0.0.683.
I'm trying to find data from one table that is not represented in a second table. Given table {Equip} and table {Tasks} I want to find all {Equip.EquipNum} that is not included in {Task.EquipNum}. My left table is {Equip}. I do have some Record Selection Formulas criteria.
I've been trying to do this by using Linkage Joins. I've tried Inner and Left Outer join, enforced to, =. Setting my Join commands to != freezes up CR when I run the report. I can get the opposite results just fine. (EquipNum must be in both tables.) Or I can also get the full data dump of {Equip.EquipNum} even if EquipNum is not in {Task}. Just not the unmatched data. Any advice? TIA -BoB-
I'm using CR 2008 version 12.0.0.683.
I'm trying to find data from one table that is not represented in a second table. Given table {Equip} and table {Tasks} I want to find all {Equip.EquipNum} that is not included in {Task.EquipNum}. My left table is {Equip}. I do have some Record Selection Formulas criteria.
I've been trying to do this by using Linkage Joins. I've tried Inner and Left Outer join, enforced to, =. Setting my Join commands to != freezes up CR when I run the report. I can get the opposite results just fine. (EquipNum must be in both tables.) Or I can also get the full data dump of {Equip.EquipNum} even if EquipNum is not in {Task}. Just not the unmatched data. Any advice? TIA -BoB-