Action Report 1

[Theredia01]

I'm pulling a rpt together of all employee(s) who have an indicator in HR_User_Data 1 and 2. Of those people, I need to list all New Hires, Rehires, Terms Action=PAY, Action Reason=PRO. I only need to see 'Action_Reason' = 'PRO' under the 'Action'= 'Pay'. Seems confusing...I'm going cross eyed. If I pull the New Hire and Terms portion, any terms who were also hired in the same 'Action Date' range, I only get one row for the most current 'Action'.

 

[CharlesCook]

"I only get one row for the most current 'Action'"

This is because you are using Effective Dating on the JOB table. Go to Selections and delete the line that says:

"effective date of table PS_JOB is report's effective date"

You will now get ALL JOB records. So you will want a selection critera of some kind to limit the number of JOB records.

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

 

[Theredia01]

It worked, I also added the selection of Any for my action, and action reason. Good to go...Thank you!