×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ALPAY010

ALPAY010

(OP)
We're currently using ADP Enterprise 3.0 Autolink.  One of the regular payroll audit reports is the ALPAY010 - Active Hourly Employees with No Hours.  I'm trying to write this in ReportSmith because I have multiple paygroups (and the Enterprise report only generates one paygroup at a time) as well as I'd like to be able to export the data.  I've thought about a Master/Detail report because I want all active hourly employees (JOB table) and any hours for that employee (AL_PDE_HRS_ERN).  Any thoughts as to how to write a selection criteria for only those that don't have any hours either because no data was entered in for them (nul hours) or only dollars passed over for them (0 hours)?

RE: ALPAY010

Quote (AtlPayroll):

Any thoughts as to how to write a selection criteria for only those that don't have any hours either because no data was entered in for them (nul hours) or only dollars passed over for them (0 hours)?

I am going to assume you can't just have a Selection Critera where Hours = 0 or is Null.




Then this is the classic "Everyone that's not here raise your hand" problem.

Just as a way of thinking this through what if you had a Selection Criteria where you manually entered the Emplid of everyone who HAS hours and excluded them.



The above critera would exclude everyone with hours.


Now what if the Selection Critera we just built could fill it's self in.  It can !!!  What you need to do is create a very simple report that only returns the Emplid of people with hours.  Copy the reports SQL and paste it into the Selection Critera we just built.  Now the Selection will have a list of Emplids to exclude.




CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

RE: ALPAY010

(OP)
I understand what you're saying but here are my thoughts.  From the JOB table, you select all active hourly employees.  As soon as you link the AL_CHK_DATA table, it's going to drop off employees who don't have any data in this table.  Is there any way other than a Master/Detail report to have a JOB (Master) with a selection criteria of the AL_CHK_DATA (Detail) having having 0 hours or nul data?

RE: ALPAY010

You can link using "Include Unmatched Records".  Watch out for you Selection Critera based on the AL_CHK_DATA fields because that will cause a problem.

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close