Hi,
I am using Crystal Reports 2008. My goal is to show the first person an employee reports up to in the management chain. I already have a table that provides this information. See illustration below:
| Employee
ID |
Level 1 |
Level 2 |
Level 3 |
Level 4 |
Level 5 |
| 12345 |
Bob Jones |
Mickey Mouse |
Tom Smith |
Jan Peterson |
|
| 423 |
Bob Jones |
Beth Adler |
|
|
|
| 555 |
Bob Jones |
Mickey Mouse |
Brad Barns |
Sarah Fields |
John Jacobs |
I would want my report to look like this:
| Employee ID | Immediate Reports to Manager |
| 12345 | Jan Peterson |
| 423 | Beth Adler |
| 555 | John Jacobs |
The first person the employee reports up to is in the last non-blank column. So I need to pull the last non-blank column for each employee. If you have any suggestions how to do this, that would be great. Thanks!
Edited by thummel1 - 01 Dec 2015 at 9:46am
IP Logged