Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 357
	Members: 0
	Total: 357

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

Training requirements

4 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

mil0n023

Veteran Member

Posts: 63

9/18/2006 8:21 PM

I have a report developed that is showing the each course (PATRNHIST) as a column, and the employee's as a row. Now, each column(course) per employee is listing (or, not) the Completion date per course.

Question, with this layout - How can I include the Status field (PATRNHIST.COMPLETE_STATS) in a new column right after the complete date, and be sure that this "F" (code for complete) is for that particular course?

John Henley

Posts: 3353

9/19/2006 10:03 AM

How are you showing each course as a column? Are you doing this as a cross-tab report?

mil0n023

Veteran Member

Posts: 63

9/19/2006 12:43 PM

We have employees for each department running down the first column, the each column across represents a course. After each course; how can I include the Stats field? And verify that the stats is for that particular course?

Maybe I can email you what I have John?

John Henley

Posts: 3353

9/19/2006 10:59 PM

If you're using a formula for mapping the rows (course) to column (course), you would also use a formula for the stats field.

mil0n023

Veteran Member

Posts: 63

9/22/2006 4:47 PM

I got this to work, but now can't seem to get a % complete on this..arrgghh