We are making dashboards to put at each work center. I have the BAQ written, working and it shows if there is active labor on a particular job. What we would like to do is show the employee’s name that is working on the job. So, I will need a formula for that, but not sure where to start.
Here is the formula we are using to show the active labor.
max (convert(varchar, LaborDtl.ActiveTrans ) )
The laborDtl table should be linkable to the LaborHdr table which contains the shop employee ID. you should then be able to retrieve the employee from the employee table.
Correct, but then it shows every name that has clocked into the operation. I only want to show the name of the current employee actively clocked in.
There is a field in Labortl for active transaction. Just filter the table to only show active transactions.
Here is a print screen to explain better. All of these jobs are ready to go into the machine center. The ones in yellow have active labor transactions on them. I want to show the employee’s name that has the active transaction and still be able to see the work que.
@hvrabbit join labordtl to your base table on jobnum,asmemblyseq and oprseq with join type of all rows from the base table. Then join LaborDtl to EmpBasic on LaborDtl.EmployeeNum = EmpBasic.EmpID for the Name field. This is also a join type of show all rows from LaborDtl.
This could make the operation shows multiple times if there are more then one active operator. In that case you would need to make the labordtl part a subquery to get a list of the active operators into one field if you only wanted the operation once.
That did it! Thanks! 
I am trying to display employees that are clocked in but not on a job. I did this several years ago, but now when I try using LaborDtl and LaborHead I only see people who are actually clocked into a job.
How can I see who is clocked in (for the day), but not yet clocked into a job?
You have to look at labor head only. So do a left join from the laborDtl so that it shows all records of active LaborHed records even if they don’t have an active labor detail.
Thanks. I figured it out. Everybody who was clocked in was also clocked into a job. So In my test db, I clocked someone in as indirect (no job) and they showed up.
