Report That Shows if the Employee Has a Photo
Created a report that will indicate if the employee has a photo or not.
Thanks to AF for the calculation syntax.
xEmp:='EMPREF='+empref
xPic:=HASRECORDSQL[xEmp,TMSEMPIC]
Use xPic as a column that will display y or N
Related Articles
How to Download an Employee to the Terminals
To down the employee to the Terminals; Select the Employee in WINTMS From the Employee Menu, Select the option Download Current Employee
Employee Rejection or Badges Not Working
Introduction This document explains how to troubleshoot badge(s) which either rejects (red light) or does not read when presented at a Mitrefinch Clocking Terminal or Access Control Reader. If the badge is rejecting then refer to section 1 or if ...
Report selection
Scheduled messages allows reports to be sent as part of a message. This provides a powerful way to automate tasks such as sending out a report of anomalies in their department to a Supervisor every week, or sending an Employee a list of their working ...
Employee details
Overview If the Employee details feature has been enabled for you, you will be able to access the information stored about you in TMS. You may also be able to modify this information. Employee details are organised in to groupings of related ...
Report profiles
The Report profiles page enables Supervisors to give the desired Employee the permission to access certain Reports. See Profile maintenance for more details. After selecting Report profiles, the following page will be displayed: The left-hand pane ...