Items with Images

[Former Member]

Hi Experts,

I want to get the item images in my crystal report. I have 1000 items with images in SAP Item Master Data.

How can i get in my report.

Please let me know if anyone face this scenario.

Thanks

[javier_facessantos · Accepted solution]

Hello Team Tech

Check this thread:

Regards

[Former Member · Accepted solution]

Hi Javier,

Thanks for reply. But not working.

for the images you need the exact location of the image file.
Since SAP stores the image file name in the Item Master data you need to querry the Bitmappath + the image file name.

Someting like this:
SELECT T0.[ItemCode],'C:\Users\notto\Pictures\Slide Shows\'+convert(varchar,T0.Picturname) FROM OITM T0
(or you can add the OADP Bitmappath to the querry but then you need some conversion to concat the Bitmappath + Picturename)

You need to replace this
'C:\Users\notto\Pictures\Slide Shows\ to the Bitmappath you set at the System Initialization / General Settings / Path / Bitmappath.

In Crystal reports insert a graphic file, then set the Image Graphic location to this string from the querry and then you get the Image of your item.

In the above contents, it is mentioned that insert a graphic file.

How we have to insert a graphic file? and set the image graphic location.?

If we insert any image, it will ask us to provide file path and then to select image. If we select image only that image will be reflected to all items.

Can you please help me out on this.

Thanks

[Former Member · Accepted solution]

Hi,

The image is for each item. You need to update each item first. The query:

SELECT T0.[ItemCode],'C:\Users\notto\Pictures\Slide Shows\'+convert(varchar,T0.Picturname) FROM OITM T0

Will get the item image file name. You need replace the folder name with yours.

Thanks,

Gordon