Crystal Report Dynamic Picture

[Daok]

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?

[Daok]

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?

[RichardAtherton]

nm

[Daok]

what nm mean?

[RichardAtherton]

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.

[Daok]

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

[Lunatic3]

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

[Daok]

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

[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.

[Daok]

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.