Skip to main content
Solved

How can I display an uploaded image on a report

  • December 15, 2023
  • 4 replies
  • 774 views
M
Freshman I

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

Best answer by sconlon88

Hello @MilanM 

Have 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 on NoteID 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 document
picturebox 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.

View original
    Laura02
    1 person likes this
    • Laura02
      Laura02
    Did this topic help you find an answer to your question?

    4 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3410 replies
    • December 15, 2023

    @MilanM  Please refer to the below links and hope these links helps.

    https://www.augforums.com/forums/acumatica-report-designer/images-for-a-report/

     

    https://www.greytrix.com/blogs/acumatica/2023/09/28/embedded-clickable-image-in-the-report/

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    M
    Freshman I
    • MilanM
    • Author
    • Freshman I
    • 3 replies
    • December 17, 2023

    Thanks @Naveen Boga 

    Would this work for adding images to an Appointment / Service Report

    I am specifically looking for the formula / script to add a signature to the report and also images to the report.

     

    Assuming:

    ={FSAppointment.NoteFiles].[Signature] for the signature?

    ={FSAppointment.NoteFiles].[Image] to display all the images on the report?

    I am still not sure what the correct string is for both

    The goal being to have all on the report once the client has signed off the service work so we can then email the report to the client with the technicians notes, any images (photos taken & the clients signature approving work done.

     

    M
    Freshman I
    • MilanM
    • Author
    • Freshman I
    • 3 replies
    • January 15, 2024

    Is anyone able to help with the above or guide me to someone that can help - fee for service please?

    S
    Freshman II
    • sconlon88
    • Freshman II
    • 5 replies
    • Answer
    • February 8, 2024

    Hello @MilanM 

    Have 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 on NoteID 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 document
    picturebox 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.

    Chris Hackett
    M
    2 people like this
    • Chris Hackett
      Chris Hackett
    • M
      MilanM

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved