Sage 100

Does anyone know how to add a dynamic image to a Crystal Report? For example, put an image of an inventory item next to the part number on a report or form?

Excellent question for the Crystal queens - Beth and Therese..............

Drop a picture on the report. In the image properties set the image file formula to the location of the picture and there you go. Image file name is in ci.item imagefile path is ...\mas90\images\<company code>. Works in crystal XI and up.

But not always. I've had issues where it did not work when it was accessing the picture across the network.

Add a pic file, any pic file, right click, format graphic, go the picture tab. there should be a Graphic location formula that you can open up and create a formula for the path based on the item code. I'm trying to find the form where I did this but am not having any luck right now, but I'll keep looking. But basically, if you have a folder with all of the items as jpgs, the item code ends up being part of the formula for that path. And it may be a little different depending on the version of crystal.

See: http://sagecity.na.sage.com/support_communities/sage100_erp/f/97/p/38909/136198.aspx#136198 The image always has to be available at the same path. I also create the report with a graphic that says something like ""Image Not Found"" in case the image isn't found; otherwise you will see the original image when the report was designed.

Thanks for the prompt replies. I just figured it out - Eric you are on the money!

Insert a ""fail safe"" graphic ( an image you want to display if there is no image available) next to the item number on your form or report. This graphic is like a place holder. Make a formula called ImageName and set it to equal your item number. Save your graphics as a .jpg using the item number as the file name. Once in place, right click on the graphic and go to Format Graphic. On the picture tab, modify the graphic location by putting in a formula that references a file name where the graphic you want is saved. Such as ""S:\Pictures\""&{@ImageName}&"".jpg"". You have to use the quotes before and after character strings. Hope this helps!

https://90minds-com.socialcast.com/messages/33424072?ref=stream