Crystal Report Dynamic Picture

I have in my database field with an ID. Each ID is link to a picture in a folder.

How can I load the picture in the CrystalReport?

I know how to add a static image that doesn't change but how can I changed the picture depending of 1 field of the query?

I will explain in other words.

I have a database :

[TABLENAME]
-id
-name
-image_path

In my program I want to show up a Cystal Report for 1 id. I have the code and it works well.

Now, I would like to add the picture that I have the path in the database. How can I have a picturebox in my Crystal Report that will be able to show the picture?

nm

what nm mean?

No message, had thought your problem was displaying a picture on a form and was posting that reply. Really for what you want to do, you are better storing the images in the database and of course then it's a breeze to include them in the report.

database will be too big later that's the problem.

I think I can help you on this. Wait and i will come with a possible answer.

Quote:

---

Originally posted by Lunatic3
I think I can help you on this. Wait and i will come with a possible answer.

---

Thx bro, I still continue to search on my side too :)

I wroked on it and i think there are two ways to have dynamic pictures in CR.

1- Load all of your images into a dataset at run time and base that part of the report on the dataset. In this case your real database file does not grow large.

2- Insert an oleobject into the report and link it to a picture file, then change that picture as needed.

The problem I faced with both of the ways is that it seems you can only use bitmaps otherwise CR doesnt show the picture.

Quote:

---

Originally posted by Lunatic3
I wroked on it and i think there are two ways to have dynamic pictures in CR.

1- Load all of your images into a dataset at run time and base that part of the report on the dataset. In this case your real database file does not grow large.

2- Insert an oleobject into the report and link it to a picture file, then change that picture as needed.

The problem I faced with both of the ways is that it seems you can only use bitmaps otherwise CR doesnt show the picture.

---

When I display picture in my program I download the file to a Byte[] and I'll display it on a picture box after. I do this cause I download the picture on a Http Server that is not connected on a lan. If I do need to use temporely database space to be able to use the picture that will load too much traffic for nothing. I might just forgot to add the picture on the Report... but grr that's not what I desired at the beginning.

I might need to change the way that user are in communication with picture then.