URGENT: How to add images from DB into reports?

[Willem2904]

Hi,

I have built a report consisting of tasks.
Each task gets an "ITP" code.

If the report code is "B" for example, I want to show an icon for "Budget"
If the report code is P, I want to show an icon for "Plan"
If the report code is A, I want to show an icon for "Approve"
(See image above, I highlighted it in red).
The ITP collumn already gets the correct info. But I can't get access to show the icons on my report.
How do I do this?

PS: I don't want to link to files on my pc, as this DB will be send by email. So everyone who would like to use the DB should have the images available inside the DB.

Thanks in advance!

 

[jdraw]

see if this helps https://www.youtube.com/watch?v=f5ZOOMrDjtU

 

[Willem2904]

I did see that video.
However, as I said, the image should be stored inside the database, not as a hyperlink.

 

[arnelgp]

If you have "ITP Code" in your table then there is a way to display icon in Report View.
Create a new table "tblITPCodeImage", the structure is:

ID Auto
ITPCode String
Pics Attachment

then on your report's record source include this table Left joining it with your original table. include "Pics" field in the query.
now draw an Attachment control on your report and set its Control Source to pics.
done.

 

[jdraw]

Willem,

Did you try searching youtube for an example of exactly what you are looking for?

Try this one

I was suggesting an approach that reduces database bloat in previous example. Since you only have a few icons, try this latest video to see how to store in the database.