Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 284
	Members: 0
	Total: 284

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Corelating Requisitions and Personel Actions

3 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

topher21

New Member

Posts: 3

12/11/2007 5:52 PM

I'm using Crystal Reports XI R1 with a regular ODBC connection and am trying to report on promotions for a set period of time and would like to try and find out (via PAJOBREQ) how many of the promotions were replacing existing headcount. I'm having the darndest time linking through between the two tables. Any suggestions in terms of structure/link type?

Chris Martin

Veteran Member

Posts: 277

12/11/2007 8:06 PM

What table are you trying to link to PAJOBREQ?

topher21

New Member

Posts: 3

12/11/2007 8:14 PM

Ultimately, I'd like to get back to PERSACTHST

John Henley

Posts: 3353

12/11/2007 8:21 PM

I'm not sure you're going to be able to guarantee an exact match/logic.
You can try going from PAJOBREQ to PAREQOFFER first. That will get you the applicant->employee link.
From there you can go to PERSACTHST and isolate the hire actions your company uses, etc. and probably get a good match.