I'm assuming by employee::hoursworked, you mean employee::EmployeeID = HoursWorked::EmployeeID.
Make a sub summary report based on HoursWorked
Make a sub Summary part (Print above, when sorted by Employee ID) to list the employee's name and and any other data from Employee that you need
Put your hours worked fields in the body
Make a second sub summary part (print below, when sorted by Employee ID, page break after every occurrence) and add any summary fields from HoursWorked to report total hours, total pay etc.
Enter browse mode and use a find to locate the desired hours. You can enter 10/2009 in a date field, for example to find all HoursWorked records dated in October, 2009.
Sort the records by Employee ID.
If you're not using FMP 10, preview the report to see the sub summary parts.
For more on sub summary reports and summary fields, check the help system.