:nix:

Anyone have an employee turnover report that they want to share? I am hoping that someone has a Crystal Report that does a good job of calculating turnover numbers for a set period with some history. Right now we are pulling all kinds of data out of Lawson with about 10 different reports and then calculating in Excel but I really want to just click a button and have a finished report.

Someone what to share or is there something built into Lawson that I do not know about????

Please

Back when I was first working on Lawson in '01, we had a consultant onsite that developed a solution utilizing pl/sql code. The code produced data that served as the data source for a Turnover report in Crystal. Most of the complexity lies withing Crystal report formulas, so it can be a bit of a bear to maintain. I'm interested to hear if Lawson has come up with any standard reports recently...

first off, dont listen to cjmart, hes a drunkard and cant be trusted, he sits right behind me and smells like a distillery :wwf:

secondly, heres a dme statement from a Lawson developed crystal report (not a standard lawson report though). This was created on mid-2002 and last updated later 2004 so take it for what its worth. Additionally, I wasnt able to run this since I dont have a test system on HR. Should atleast get you pointed in the right direction.

hth
matt

Hmm, a dump of PERSACTHST. Insightful post by Mr Nye. :bs:

I'll take a few minutes offline to explain to him that a list of Terminations <> Turnover report. :beat:

FYI - He actually could've run it on the Lawson system we both have access to, he's just too lazy. :tyson:

you all will have to forgive Chris hes a little slow and the DBA has been getting to him lately. :P

add this as a selection clause
{Command.ACTION-CODE} in ["NEWHIRE", "TERM"]

Do a cound for each then plot the counts on a graph or crosstab query with time as your y axis, is a common way to track turnover trends. If you can post some metrics you are looking to track I can be more specific.

hth
matt