Number of Employees Receiving Paychecks over Period

[AtlPayroll]

I've got a report that lists all of the paycheck generated within a period of time. This report also has a summary footer that sums up the Gross & counts the total of Number of Check. I'm trying to get a summary of the number of unique employees getting checks. If there are multiple pay checks over the period of time, one employee could receive multiple checks, but I need the employee counted only once. If there a way to summarize the number (count) of unique employee (EmplID) either by the Summary Field or Derived Fields?

 

[CharlesCook]

Use Database Grouping and COUNT(DISTINCT EMPLID)

This is a PCPW example but you will get the idea.

http://charlescook.com/PPS/ADP/ReportSmith/PCPW/DatabaseGrouping.pps

Charles

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting