Inserting Pictures dynamically 1

[faroe]

I have a series of images stored on a hard drive showing various logos. The images are not stored in the Oracle database along with the other data I am using.

In my crystal report I have a group based on the field {companyname} and I wish to display the appropriate logo for that company. E.g if {companyname}=ABC then display the image ABC.psd (Adobe).

Is it possible to create a OLE object in my report with a File Path that can be controlled via a formula? I can insert a single image as an OLE object but this obviously does not change from group to group.

I have also tried using a Hyperlink. Whilst I can create a dynamic link to the file, the image opens in the 'parent' application and is not inserted in the report. Am I missing something here?

Thanks in advance.

 

[pelajhia]

If you can put these into an access database, you should be able to display them dynamically.

 

[paulmarr]

Although this is a feature of Crystal Reports XI - this is not possible in previous versions of Crystal. You either have to embed each logo in a separate group header (you can split a group header any number of times) and suppress all but one - depending on the company . . . or as the previous post suggests - store them in a database and pull them out that way.

Crystal XI allows dynamic images in a report from a file structure.

I hope this helps

paulmarr

 

[faroe]

Thank you for your replies. I will await our upgrade to v11.

 

[chelseatech]

You don't need an upgrade. My cViewIMAGE utility will do this for Cr8.5 and later. Download a trial version from my web site.

Editor and Publisher of Crystal Clear

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

 

[kmcginn]

Paul,

Can you explain how to do this in Crystal XI, please? We are about to embark on a project which will utilize this function.

Thanks so much,

Kris McGinn

 

[paulmarr]

Sure,

Crystal XI allows you to store images (wmf,jpg,bmp,tif file extensions) in a file/folder structure/directory - and store the file path location as a string in your database.

Based on this field - Crystal will fetch the required image and display it on your report.

This has been a feature users have been asking for over the last few years and BO has delivered!

Cheers,
paulmarr