I need to display data in my report in a particular way and I cannot work out how to do it. I have attached an example of the data.
Where the change reason is Internal Recruitment there is an Occupancy End Date, this represents the job that the person vacated I need to show the Grade that is associated with this. I also need to show the Grade of the job that they moved into, which is always the next day after the Occupancy End Date. It shows as Occupancy Start Date. How do I go about showing the name of the Position and Grade they moved out of and the Position and Grade they moved into.
By the way my report will list many different employees so I need this to work by employee.