AnsweredAssumed Answered

Setting up a payroll report

Question asked by addison on Aug 4, 2016
Latest reply on Aug 5, 2016 by Johan Hedman

I have a timecard database in which one record represents one day. I have separate tables for Employees (name, ID number, etc.) and Pay Period (start and end dates).

 

Every pay period (two weeks) I want to be able to generate a report for our payroll provider that will compile the daily records into a format organized by employee, and for only that pay period.

 

I am struggling to understand how reports work, and especially sub-summary parts. It looks like I will want to sort by the fields EmployeeID and PayPeriodEnd (each daily record will have this information associated with it).

 

I want the report to look something like this:

 

Employee ID                     Name

        

          Pay Period End

                                        Day 1 Regular Hours                                          Overtime

                                        Day 2 Regular Hours                                          Overtime

                                        Day 3 Regular Hours                                          Overtime

                                        etc.....

                                      

                                        Total Regular Hours for Pay Period             Total Overtime Hours for Pay Period

 

I've created a report layout, but I have no idea how to get to what I'm trying to achieve.

 

Thank you for any help!

Outcomes