Display image in a report

[tmarsh]

I am trying to display an image for each record in a report. I have a form based on a table (basically pinched from Northwind) that works OK but I can't figure how to make it work in a report.

I'm not storing the images in the table, they are linked.

 

[HiTechCoach]

What are you having trouble figuring out?

Do you have a question?

Maybe another example will help.
Picture in a Report

Demonstrates a method of displaying a picture/image file in a report without storing the image in a table.

 

[tmarsh]

What are you having trouble figuring out?

How to place an image on a report that changes for each record in the report. I have it working on a form but I don't know what to link the image frame to in a report.

 

[Mattster]

I do an on format function that basically renders an image. I have a sub form that contains only an Image place holder that I properly size.
In the main report, I place that subreport and also provide a field with the Image file path. In VB I have written this simple code.


' Verifies that the imagepath is not null
If IsNull([ImageFilePath]) Then
[SubReport].Report![ImagePlaceHolder].Picture = None
[SubReport_Image].Report![ImagePlaceHolder].Visible = False
Else
' Verifies that the imagepath is valid for this system
If Not (Dir([ImageFilePath]) = "") = 0 Then
[SubReport].Report![ImagePlaceHolder].Picture = None
[SubReport].Report![ImagePlaceHolder].Visible = False
Else
[SubReport].Report![ImagePlaceHolder].Picture = [ImageFilePath]
[SubReport].Report![ImagePlaceHolder].Visible = True
End If
End If



I hope this helps