Dynamic graphic location

[prgmrcr]

Hello forum members,

I have a crystal report that uses dynamic graphic location. We store images for different states in USA. Some of the state images are not in the windows file system but we have records for those states in the database. We can store the images to make it work but I want to know how to display a blank or suppress the OLE object if the image is missing for that state.

Thanks in advance.

 

[beltmanjr]

You could consider storing the images as blobs in the database. This way a NULL value would indicate the missing of the image.

 

[prgmrcr]

Beltmanjr,
Thanks for taking your time.That is a possible solution but we will not be going in that direction. Please let me know if there are any other alternatives. Thanks a lot.

 

[beltmanjr]

How do you currently dynamically set the image path?

 

[chelseatech]

The problem with dynamic images inside Crystal Reports is that if the calculated image path doesn't exist, then the original image is displayed.

So use as your original image, the picture you want to display if the state can't be found.

my cViewIMAGE utility returns a NULL image if the file doesn't exist. Seems to be clearer that way

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[prgmrcr]

Chelseatech,
I used the cviewimage utility for the images that do not exist and it worked. Thanks a lot for the help.