Training requirements - LawsonGuru.com - LawsonGuru.com Forums -

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

mil0n023

New Member

Posts: 0

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: 3366

New Poster

Engaged Reader

Avid Reader

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

New Member

Posts: 0

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: 3366

New Poster

Engaged Reader

Avid Reader

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

New Member

Posts: 0

9/22/2006 4:47 PM

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