Finding unique persons in tables with persons, employments and transactions?

Post Author: AndersG

CA Forum: Crystal Reports

Hi!I guess it is just that time of year for this type of report...Anyway assuming that I have three tables one with people, one with their employment info and a third with actual payments. I want to create a report of how many people there are per position for example, based on whether they have any actual transactions this year. It works as long as I do no try counting per postition since one person can have moved from one to another during the year. In this case they will have one record in the people table, but two in the employment one. In this case the same person will show up twice, once under say" HR" and another under "SALES", how do I get around that??