We are running a report that lists the Opportunities (the courses the student is taking) attached to individual Person records (the student), filtered by a Tag (the semester in which they are studying). The Opportunity relates to them through a Custom relationship field.
The report is showing Opportunities that the student is no longer related to (because they swapped courses), even if I slap a date filter on it…
Can anyone advise what is happening, and how to ensure that only those Opps that the Person is connected to show up, please?
Best answer by Chris from CopperView original