Missing images in continuous report

[ksimpson61]

I have a report that pulls information for each unit. I have set up a filter so that the user can pull a report for one unit or several units based on region. Each unit's report is about 5 pages with the last page being a jpg of a site plan. If I pull the report up with more than just one unit, for example one region might have 9 units, some of the images do not generate and it seems to be random. I think this might be a memory issue, but was hoping there was a workaround, such as some VBA code that I might be able to use to loop through each unit to make sure that the image generates. The image is not embedded in the underlying table, but rather I am using a text field with the path of the pictures' file.

 

[Ranman256]

In the detail band, onPrint event,
Load the image for every record,
ImageBox=txtBoxPath

 

[ksimpson61]

Thank you for your response. I tried the inputting the following in the On Print event in the detail section of the subreport where the imagebox is located:

[ImgBxSitePlan]=[SitePlanName]

Where ImgBxSitePlan is the name of the image box and SitePlanName is the field where the image path is stored. I re-ran the report and out of 21 possible images, 3 were missing. Did I misunderstand? Should I have put it in the detail On Print event of the parent report? or am I using the wrong controls/names?

 

[Ranman256]

If the photo path is in the main report,put it there.
If the photo rec is in the sub rpt, put it in the sub rpt detail onprint.

Why it is skipping, I don't know.

 

[JHB]

Only because of interest, is it always the same images that are missing?
And how about the missing images filesize, are they bigger as the none missing images?

 

[ksimpson61]

In response to JHB...the missing images are random. Not always the same one(s) and the size of the picture file(s) doesn't seem to matter. I checked the report I ran yesterday and there were pictures that were over 1,000 KB generated, but some that were around 750 KB that were missing.

 

[ksimpson61]

Ranman256 - That's what I thought. I put it in the correct place. Thanks for your help.

 

[ksimpson61]

JHB - I re-ran some reports and found that the missing images are not random. It seems to be the same images that are missing, assuming it is a multi-unit report. However, when I pull up a report of only images or if I pull up the full report but for only one unit, the image shows up. That was why I thought it was random.

 

[JHB]

I read your answer as if you still have the problem!
Only to eliminate possible errors I would replace the problem images with some of them which shows correct, (rename them to the problem images name).
If they now shows correct, then something with the problem images aren't okay.
If they not shows correct, then something else as the image is the problem, maybe something with the path is wrong, or the report shows before the image is fully loaded, (report speed) or what ever it could be. Difficult for me to say without the database, I'm only guessing.
If you can't get it, then post a stripped down version of your database with some sample data + the one image which shows correct and one which doesn't show correct, (zit it).

 

[ksimpson61]

Yes, I'm still having issues. I have been playing around with how the file was saved, named, etc. If I use a different image that works and rename it to an image that wasn't working, it works. So it must be the image, right? However, I played around with one of the non-working images and finally got it to work. Not sure how. Probably just a fluke, but it has been displaying over and over now. I am trying with some of the other images to see if I can get them to work, but not having much luck. I looked at the properties of both a non-working image and an image that works and I can't find any glaring discrepancies. I'll try again on Monday, but if you have any ideas in the meantime, I would be open to hear any other suggestions. Thank you for your help!

 

[JHB]

The way you describe it, it sounds for me that it is something with the image.
Can't you get a new image of the same?
What if you save the image to a new file name, and then rename it afterwards?
What if you save the image to a new file type, (bmp, jpg etc.) and then open it and save it back to the same file type?
Or take a print screen of the image and save the print screen!
As mention before - post a stripped down version of your database with some sample data + the one image which shows correct and one which doesn't show correct, (zit it).