Hi Rawns. Initially the preview showed expected results but the output showed many duplications which masked the identification of the medical notes issue.

Once I removed the field and reran the report the 'inexplicable' duplications disappeared and made it easy to ID the root cause. However, once I added the field back in the spurious duplications did not reoccur?