Make image object variable in Crystal Reports 10

[SarahVandenbroucke]

Hi,

I wonder if the following is possible:

We have a table Person in our database, with the fields p_person and name. (p_person is the unique identifier)

We have a folder: C:\Pictures that contains a picture for each record in the table Person. The name of the picture file is the unique identifier of the record in the Person table, eg "123456.jpg". We do not want to store the pictures in the database!

Now we want a Crystal Report with a list of the persons from the table Person, their name and the picture from the folder C:\Pictures. Since each record has a unique identifier, p_person, and the image files are named p_person & ".jpg", we know what picture goes with what record.

How can you make the image object on your crystal report variable??

Any help would be much appreciated!

Thanks,
Sarah

 

[synapsevampire]

Store the location as a hyperlink in your table, then insert it into the report, right click, select format text->Hyperlink Tab->A file

Keep in mind that if people are running this hyperlink from other machines, you wouldn't want to use explicitly drive mappings (C, use the machine name (\\Macine1\pictures\...)

-k

 

[chelseatech]

You could also use our cViewIMAGE utility. It is a COM data driver for CR. You use it as the source for a subreport and link in the file name - it returns the image as a field in the COM record.

Go to

http://www.chelseatech.co.nz

for details.

Editor and Publisher of Crystal Clear

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

 

[SarahVandenbroucke]

Thanks for your reply, synapsevampire.

I tried it, but it didn't work.
I have put the hyperlink in the table, inserted it into the report and set the Hyperlink type to a file.

When running the report, I only get the hyperlink-text (\\Testmachine\123456.JPG), no image.
What am I doing wrong??

chelseatech,

Thanks for this information.
Do you have (good/bad) experience with this tool?
Do you know when purchasing this product, do all of our customers also have to purchase it too, or can we just install it with them?

Thanks!
Sarah