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

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

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

• TMS 8 8.36.7.1 General Release Report

  We are pleased to announce the latest general release of TMS 8: version 8.36.7.1!  Please refer to the table below to view a list of the key features introduced for TMS 8. More information about the features can be found in  this  PDF, plus details ...

• TMS 8 8.36.2.1 General Release Report

  We are pleased to announce the latest general release of TMS 8: version 8.36.2.1!  Please refer to the table below to view a list of the key features introduced for TMS 8. More information about the features can be found in this PDF, plus details on ...

• TMS 8 8.32.0.2 General Release Report

  We are pleased to announce the latest general release of TMS 8: version 8.32.0.2!  Please refer to the table below to view a list of the key features introduced for TMS 8. More information about the features can be found in this PDF, plus details on ...