Candidates "Never Been Hired"
SummaryAttempting to run a report of any Candidate that Has never been hired
Currently we have candidates that apply to multiple reqs, and i have attempted to build a report that exclude any Cands who do not have a current or historical submission status of "Hire". thus the issue my report is having is that it still reports out the candidates other submissions in which they have been New/Rejected on. I only want a true view of any candidate in our system that have never been hired!
Any help or trick to do this please advise!!!
I only want 1 row per candidate.