Need List of Emps Working in Multiple Company Codes

[chenry01]

Is there a way to create a ReportSmith report with ADP PC/PW tables that list only employee's who have been paid in Multiple Company Codes and who were paid over 40 hours total between all company codes.

 

[CharlesCook]

If you use Database Grouping you can do a SQL Derived Field with COUNT(DISTINCT COMPANYCODE). Then you can use that in the Database Grouping Selections. You can also create a SQL Derived Field and count the hours WITHOUT DISTINCT and use that in the Selections.

Take a look at:

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

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting