Termination Report with Last Salary

Content

I am trying to create a report that has both the reason the employee has left the company (i.e. Voluntary, Involuntary) as well as the salary the employee was receiving at the time of termination.  I started with the Salary History Details Report and using a MAX filter am able to find the most recent salary for the employee.  When I try to bring in Termination Category from any Workforce Management subject area, the Termination Category column pull all blanks or the report errors out.   Can you please let me know if there is an SQL I need to add