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 ...