Need Help with Report Designer

I'm currently working with a standard job cost report that shows employee hours at T&M rates with certified classes on it, but it is actually pulling the certified class from the employee set up. I want it to pull from the actual weekly payroll certified class. I think I need to create a LOOKUP formulas, but having issues with it. Can anyone help? I'm using report designer Sage 300.