The Acumatica Report Designer allows you to link to any table and then show the pictures attached to a row.

When you attach pictures to a rom in your BOM,  the pictures are ultimately stored in  the UploadFileRevision.BlobData field. You can link to this table by joining the relevant AMBom**** table with NoteDoc (ex: AMBomStep.NoteID=NoteDoc.NoteID) and then with UploadFileRevision on the FileID field. You can technically have multiple images per item so you'll either need to filter by file name (ex: image should always be called "PartDiagram.png") or use a subreport that will print out all the images.

The Picture box control can be bound to a database field (Source=Database, Value=select the UploadFileRevision.BlobData field). The VisibleExpr property can be used to control whether or not the picture box shows. More information on the picture box can be found here.

Hi @Gabriel Michaud , I tried your approach but with a different screen altogether. My scenario would be to grab the picture with the prefix of “signature” since Acumatica mobile app will automatically name it as “signature<uniqueID>.png” if I were to sign it via mobile app in Appointment screen.

I’ve tried linking FSAppointment with NoteDoc on NoteID and then with UploadFileRevision on FileID and calling the value FileUploadRevision.BlobData] on a Picture Box with Database as its source, but I got an error indicating “Unable to cast object of type 'System.Byte ]' to type 'System.StringS]'.”. Am I missing any step in actualizing this?

PS: I’m able to get the image if I directly use the FSAppointment.NoteFiles] field, but this will only select the first image uploaded into the document.

Hi @ericklasimin61 -- can you share a screenshot of the report designer properties toolbox for the image control?

Hi @Gabriel Michaud , I managed to get it to work by using subreport instead. The table linkage is quite similar to yours with the exception of UploadFileWithData instead of UploadFileRevision. As for the value used for the picture box, I used [UploadFileWithData.Name] and implemented string logic to grab the the signature image and ignore the rest.

Using UploadFileWithData and dUploadFileWithData.Name] worked for me. Thanks

I am now also trying to do something similar. would you be able to provide a copy of the Value including the string logic please.

I am trying to add the (client’s) signature onto a Service Report in a Picturebox. And also add images (photos taken by technicians) in another Picturebox. Just not sure how to write the value, assuming though that the source being the Database is correct?