Skip to main content
Answer

Employee Timesheet Report/Timesheet History Report certifying signature picture

  • May 23, 2025
  • 3 replies
  • 68 views

whecht
Freshman I

The Timesheet History Report is the main one I am looking at as it already lists the Submitted By and Submission timestamp as well as the Approved By and Approval timestamp. Is there a place to upload an employees signature to be referenced to show up in the report?

I know there is for Cash Accounts, but for individual users? Would the Email settings area of User Preferences be the best option, or even work?

Best answer by Ankita Tayana

Hi ​@whecht ,The solution requires customization or a custom view. The Report Designer alone cannot easily handle binary image retrieval without code support.

You need to customize the Signature tab on the Employee screen, similar to the one on the Cash Account screen.

Workaround Solution:

1. Store the Signature as a File Attachment on the Employee Record

Steps:

  • Navigate to the Employees (EP203000) screen.
  • Use the Files tab (paperclip icon) to upload a signature image (e.g., PNG or JPEG).
  • Ensure each image file is consistently named (e.g., "Signature.png").

In the Report Designer:

  • Use a subreport or a custom SQL view to retrieve the signature image.
  • You will need to join the UploadFile and NoteDoc tables to get the image binary using the NoteID of the Employee record.

    Note: This approach requires customization or a custom view. The Report Designer alone cannot efficiently handle binary image retrieval without code assistance

3 replies

Forum|alt.badge.img+5
  • Jr Varsity I
  • Answer
  • June 3, 2025

Hi ​@whecht ,The solution requires customization or a custom view. The Report Designer alone cannot easily handle binary image retrieval without code support.

You need to customize the Signature tab on the Employee screen, similar to the one on the Cash Account screen.

Workaround Solution:

1. Store the Signature as a File Attachment on the Employee Record

Steps:

  • Navigate to the Employees (EP203000) screen.
  • Use the Files tab (paperclip icon) to upload a signature image (e.g., PNG or JPEG).
  • Ensure each image file is consistently named (e.g., "Signature.png").

In the Report Designer:

  • Use a subreport or a custom SQL view to retrieve the signature image.
  • You will need to join the UploadFile and NoteDoc tables to get the image binary using the NoteID of the Employee record.

    Note: This approach requires customization or a custom view. The Report Designer alone cannot efficiently handle binary image retrieval without code assistance

whecht
Freshman I
  • Author
  • Freshman I
  • June 3, 2025

Ankita, thanks! That’s what I was thinking, and you confirmed the complexity of the possible process.


whecht
Freshman I
  • Author
  • Freshman I
  • June 17, 2025

@Ankita Tayana Hey! Just an update, but I was able to treat it much like a logo file from the Locations screen. 

I followed your first step, but to get around needing a consistently named image file or any extra things in the Report Designer, I created an attribute in the Employee screen where I c/p the Wiki Link of the file I saved in the file tab. In the Report I simply reference the attribute field which fed in the specific link information. This way the specific title of the signature file doesn’t matter as long as the attribute section is updated any time you update the signature picture in the file tab.