Aug 29, 2006 #1 RptSm MIS Dec 28, 2004 19 US I am trying to create a report that only shows employees that have mutiple checks for a given pay date. Any help would be really appreciated.
I am trying to create a report that only shows employees that have mutiple checks for a given pay date. Any help would be really appreciated.
Sep 2, 2006 #2 CharlesCook Programmer May 13, 2002 424 US From a very high level you could: Create a report using Database Grouping. Then create a Derived field to Count the number of records per person. Then use that derived field in the Database grouping selection critera. CharlesCook.com ADP - PeopleSoft - SAP ReportSmith - Crystal Reports - SQR - Query - Access Reporting - Interfaces - Data Mining Upvote 0 Downvote
From a very high level you could: Create a report using Database Grouping. Then create a Derived field to Count the number of records per person. Then use that derived field in the Database grouping selection critera. CharlesCook.com ADP - PeopleSoft - SAP ReportSmith - Crystal Reports - SQR - Query - Access Reporting - Interfaces - Data Mining