Sage 100

How to display Image of Item Code image file on Sage 100 Crystal S/O Invoice or Order forms? Does anyone know how to setup a Crystal form like a Sales Order to print the image of the item code attached to item on lines tab of data entry and then be dynamic to update the picture for the multiple lines. Goal is to print each items picture when a Sales Order or S/O Invoice is actually printed out. @DanBurleson

Bruce - Picture tab for the Format Editor of the graphic - there is a formula where you can stick the path to the graphic. You start by putting any old graphic in there, then edit it to be based on the item's graphic.

Great info, do you have any info on the formula needed?

You'd have to concatenate the hard coded path to the file name stored in CI_Item

Here's an example of the formula. ``` ""\\SERVER\MAS90\Images\TST\"" + {CI_Item.ImageFile} ```

What @DavidSpeckII said and what @BethBowers said.

I was looking for this today and ran into some snags. I thought I would share what the final resolution was. In the Format Graphic conditional formula I ended up using the following if-then: if isnull({CI_Item.ImageFile}) = true then """" else if {CI_Item.ImageFile}="""" then """" else ""\\servername\MAS90\Images\ABC\"" + {CI_Item.ImageFile} In conjunction with the above formula, I used a trick that pulls an image called ""Not Available"" every time it does not find an image (see URL below). https://it.toolbox.com/question/how-to-display-jpg-file-in-crystal-report-using-file-path-from-sql-table-100407 P.S. I did not use SQL table, just ProvideX. Hope this helps.