View Full Version: Reporting Heirarachy

LawsonTalk > HR/Payroll > Reporting Heirarachy


Title: Reporting Heirarachy
Description: crystal


Mil0n023 - August 30, 2006 10:45 PM (GMT)
In Crystal can I get a reporting hierarchy for the organization (i.e. dept's flowing up through managers, directors, etc.)?

If so, where is this data?

SAH - August 31, 2006 10:11 AM (GMT)
Depending on what pieces you use, you'd need to tie together PRSYSTEM, DEPCODE, SUPERVISOR, JOBCODE, POSITION, etc. - hard to provide suggestions without knowing what you're using in your set up. Good luck.

kate - September 4, 2006 03:21 PM (GMT)
Try the HRSUPER table.

shanesmj - October 3, 2006 04:10 PM (GMT)
I have a crystal report that I created that goes 8 levels deep... You enter the employee # at the top of the level you want and it shows everyone that reports to that person with their reports... and so on for 8 levels.

Give me your email and I will forward it to you....

Shane



Hosted for free by InvisionFree