Correct Pay Rates

I need to generate a report that lists all my employees, all their hours worked, vacation hours, sick hours, vacation hours, etc. with the correct pay rate connected to each entry of hours.  This is to cover an entire year so I'm not excited about having to manually put the information together with over 400 employees.  I tried to custom build a report but I still get the exact same pay rate for every employee.  Thank you in advance for any assistance or advice you have to offer.