Skip to main content
Solved

How to display images in report designer not knowing the image name

  • July 9, 2026
  • 2 replies
  • 25 views
J
Varsity I
Forum|alt.badge.img

Client is taking pictures of packages during the shipping process and wants to send those pictures to the customer in the shipment confirmation report.  The link between the Shipment table and the UploadFile table works fine and assume that we are only returning .jpg files.

There are two fields of interest in the UploadFile table:  Name and ShortName as they display in a text field.

  • Name field:  Sales Orders (011110)
  • ShortName field:  receipts camera352545645 20260602T203435 522.jpg

To display the image with database as the source, I used the formula:

 = [UploadFile.Name] + '\\' + [UploadFile.ShortName]

The issue is that it errors with:

The link ‘Sales Orders (011110)\receipts camera352545645 20260602T203435 522.jpg\receipts camera352545645 20260602T203435 522.jpg’ was not an image

I can’t find anyway to get the ShortName to not repeat.  I’ve tried substring, instr, and left functions.

Any ideas?

Best answer by johnw51

Never mind.  The entry in the picture box should be just  = [UploadFile.Name]

In a GI, the field displays the show file name but in a textbox in report designer, it only shows the first part of the name.  Not sure why the difference, but it works now.

2 replies

J
Varsity I
Forum|alt.badge.img
  • johnw51
  • Author
  • Varsity I
  • Answer
  • July 9, 2026

Never mind.  The entry in the picture box should be just  = [UploadFile.Name]

In a GI, the field displays the show file name but in a textbox in report designer, it only shows the first part of the name.  Not sure why the difference, but it works now.

    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • July 9, 2026

    Thank you for sharing your solution with the community ​@johnw51!

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsAccessibility statement
    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