Try this standard Payroll Summary report:
sp_report PayrollSummary show AmountHours_Title, Label, AmountHours, AmountRate, Amount parameters DateMacro = 'Today', SummarizeColumnsBy='Employee'
or for a specific time period:
sp_report PayrollSummary show AmountHours_Title, Label, AmountHours, AmountRate, Amount parameters DateFrom = {d'2007-03-01'}, DateTo = {d'2007-03-31'}, SummarizeColumnsBy='Employee' |