Dynamic image in .FRXs?

[mcoupal]

I have a report in Fox 3 that's used by several users and is supposed to show their signature (a .bmp file) at the bottom. Currently, I am using one report with several .bmps on top of each other, displaying only the correct one. However, this is very difficult to maintain.

Is it possible to use one Image field on the report and make it reference different .bmp files based on a variable at runtime?

Or is there a better method? Maintaining several different reports with a different signature .bmp would be very difficult to maintain. I would prefer to avoid using a rich text field for storing the image.

 

[AChiado]

Hi mcoupal,

you can store your filename in a variable
Es. myPicture="c:\pict.jpg"

Then in the controlsource of oleobject in your report put

&myPicture Andrea C.P.
Italy

 

[mcoupal]

Hi there, I tried using &Filename in both the "File" and "Field" control sources in an Ole picture object but it's still asking me for a filename for the .bmp at runtime. Any suggestions?

 

[mcoupal]

Oops.. my mistake.. It does work. Thank you!