How can I display an uploaded image on a report

Question

Hi there, newbie to Acumatica here and I hope someone can help.

I have a workflow where my users (field services) will complete an FSAppointment and upload image files to support the work. The customer will then sign that the work was done. There are three files I can see uploaded in Files, two with a prefix “image_” and one with a prefix “signature_”.

I want to add the photos and signature to the appointment report with the photos of the work and the customer signature on each report..

I have tried to display using =[FSAppointment.NoteFiles] but the first image is displayed.

How can I specifiy the signature and/or the uploaded files?

Thanks

Milan

icon

Best answer by sconlon88 8 February 2024, 19:52

View original

sconlon88 · Accepted Answer

Hello @MilanMHave you found an efficient solution to your scenario? I have come up with something that may work for you.If you left join the document’s table onNoteID to NoteDoc.NoteID, you can inner join NoteDoc.FileID to UploadFile.FileID. In the relations of the NoteDoc to UploadFile inner join, put an AND operator, then on a new line the parent formula will be =INSTR(CSTR([UploadFile.Name]),’image/signature’), EQUALS, and the child formula will be =1. You will need to add this join for each different type of image, like the image or signature tags, because it apparently only pulls a single image. Then, in the PictureBox, you will need to select the source as Database and the value as =[UploadFile.Name].joins and formula to reference and isolate attachments to the documentpicturebox settings​​I hope this helps you out, and if you have already found and answer I would love if you could share it, since the solution I’ve provided will not work with the high throughput of reports that need to use this method.