-
1
- #1
Using Reportsmith for Enterprise, SQL, what would be the best method for reporting the current JobCode and the one most previous to that, without capturing all?
The scenario is: someone that has an Action Reason "JTC" with the Action Date being within my specific date range. I want to know the employee's current JobCode and their JobCode immediately prior to the current one. I don't want their entire history however.
ThanX for all the help ya'll provide.
The scenario is: someone that has an Action Reason "JTC" with the Action Date being within my specific date range. I want to know the employee's current JobCode and their JobCode immediately prior to the current one. I don't want their entire history however.
ThanX for all the help ya'll provide.