I need to create a Crystal report that shows personnel changes for the current month. We capture all the info in Acitivties: specific positions (in Activities.UF_2), start/end dates, etc.
So here's and example of the problem: I need to surface those we have added new and those who have gone off the register. Pulling the new is easy as I just need to put in, for example, all those with effective date in current month and position = "TREASURER." But to show those who have gone off, their position will be listed as "former" or "unassigned" in the current activity and I must qualify their position as "Treasurer" from the previous activity.