Personalization, Customization and Productivity Tools

[rmikolainis]

Is there a way to insert the pictures associated with an inventory item into a Crystal Report? I tried using the OLE Object in Crystal with a formula for the ImageFile field in the CI_Item table. Any push in the correct way to do this would be a helpful, thanks!!!

[rmikolainis · Accepted solution]

Mental Note: Make sure to have at least my first cup of coffee before posting.

I figured it out, I needed to make a formula to where the image file is located and add the imagefile field to that formula then.

Working perfect.

[connex]

What version Crystal are you using?  I believe this i a new feature that only works with version 11.

[rmikolainis]

---

connex wrote:

What version Crystal are you using?  I believe this i a new feature that only works with version 11.

---

Version XI , for 4.40.

I unchecked the "can grow" also. Made the report look a lot nicer. It just squishes the image if its too big though.

Any better tip for controlling the image size?

[connex]

If there is ever the chance that a record will not have a corresponding image file, then the image that you inserted initially will be display.  This allows one to use an "Image Not Available" graphic for this situations.

[photo7589]

Hi Guys

This dynamic picture in Crystal 11 seems to be a great solution to a maxed out Access Database.  However I'm having some issues getting this to work.

I am trying to add the pictures to the Sales Order Printing form.  I inserted an OLE Object and 'create from file' choosing the ABC Company Logo (temporarily using this to show if there isn't a picture for the item).  After inserting this object, I right clicked, format graphic, picture tab, graphic location, conditional button.

It is here I run into problems unless I've missed something in my above process.  What is the formula to set the path to the images and reference the CI_Item.ImageFile field.

I would also like to add a second picture for the same item.  In MAS we utilized the Alias Item (General Alias, same item # with an A behind it) and in the Access DB, we had a field for the Alias Item and the pix was named the same way (with an A behind the number).  If I could get a second ImageFile field put on my IM Maintenance or into the Alias Item table, do you think it would work to follow the same steps but reference either the ImageFile2 field or Alias Item ImageFile (custom programmed).  Do you have any other ideas to solve this second picture problem?

Thanks

Nancy

[rmikolainis]

Nancy,

The formula I used is simply "file location" + CI.Item  , so, mine looks like this:

"C:\MAS Installs\Testing\MAS90\Images\ABC\" + {CI_Item.ImageFile}

[photo7589]

You rock!

Thank you so much, you have just made my Thanksgiving!!

Nancy

[bdelgado]

I tried using the OLE Object and updated the path and it just shows a little dot on the printed order not the image. What am I doing wrong?

[DHANSEN9]

My client is still on 4.30, so they are on crystal 10.  Has anyone gotten the picture to pull in in crystal 10.  I see the suggestion to pull in a picture and then go to Format graphic, Picture Tab, then Graphic loation, but that does not exist in crystal 10 for version 4.30.  Anyone able to get that to work in crystal 10?