Report That Shows if the Employee Has a Photo

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.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 ...
    • TMS 8 8.27.8.0 Release Report

      We are pleased to announce the latest release of TMS 8: version 8.27.8.0! This version of TMS 8 introduces the following new features: Multiple Submits are now disabled Once you click primary actions on a form (such as Submit), the button is now ...