Hi all,
I have a database that tracks employee training. When a person walks up and asks "Who doesn't have this/that training?" I am kind of stuck. I can only display who has what training, while not being able to tell them who doesn't have that training.
For instance. I can generate a report (rptCalendarSearchSummary) that will, if a person has "X" training, displays a 1.
I would like this report to include all employees, regardless of whether or not they have the training, and just display a 0 if they do not.
I'll attach pictures to give a better idea.
Is there something I have to change in the way the data is grouped? Or add something else to the "CurrentAppointments: Sum(1)" field?
PS, the names are blurred for company reasons. Try to imagine a list of names