Access subreports do not always show graphs (in .jpg format)

I have a report that includes a large number of subreports.  Each subreport can include up to 10 graphs.  Each graph is referenced through an OLE control where the Picture property field specifies a .jpg file at a network location mapped as a drive (for example, "H:\WorkingFiles\NIMTchart.jpg")

When the report is run some graphs do not display.  If I open the subreports directly, all graphs are correctly displayed.

It's as if, when the report is run, and a subreport is opened for inclusion in the report, there is only a limited amount of time allocated to each subreport page.  If not all graphs on a page can be generated in the time available then maybe the last one gets left out of the report.  A typical case has a report page showing three out of four graphs, with the bottom right hand graph missing.

The missing graphs will not be the same every time the report is opened.

I have just converted my database to Access 2010 (.accdb) from Access 2003.  This report ran without problems under Access 2003.

What can I do about this?  Help much appreciated!
tonewellAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tonewellAuthor Commented:
Problem also occurs when Access 2010 is used to run the database in .mdb format.
0
Jeffrey CoachmanMIS LiasonCommented:
<I have a report that includes a large number of subreports.  Each subreport can include up to 10 graphs.  Each graph is referenced through an OLE control where the Picture property field specifies a .jpg file at a network location mapped as a drive (for example, "H:\WorkingFiles\NIMTchart.jpg")>
I'm confused, ...are you displaying Graphs, or images of graphs, ...or both, ...or neither?

The first thing I would do is make *Sure* you are only opening this report in "Print Preview" explicitly.
Many report elements are not rendered accurately in "Report View" (which is the default)

JeffCoachman
0
tonewellAuthor Commented:
Clarification: I meant images of graphs.

Yes, the problem occurs when opening the report in "Print Preview".  It also occurs when the report is output as a .pdf file under vba control.

(I have tried opening the report in "Report View" ... that produces a whole different kind of mess; but that is not what I am concerned about.)

Any other ideas?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

tonewellAuthor Commented:
It appears that the problem is that Access is not handling LAN/WAN latency well.  I have moved my "working directory" to my C: drive; doing so seems to solve the problem.

Do the experts have a better answer?
0
tonewellAuthor Commented:
I spoke too soon.  Further investigation shows that the problem is NOT solved by moving my "working directory" to my C: drive.  Thus LAN/WAN latency is not the core issue here.
0
Jeffrey CoachmanMIS LiasonCommented:
My thoughts:
This, to me, has to do with the level of complexity here:
a. Subreports
b. A "large" number of subreports
c. Images in a "large" number of subreports
d. Multiple images in a "large" number of subreports
e. Multiple OLE images in a "large" number of subreports
(Also compounding this issue will be the size of the images)

Access report were simply never intended to work like this.
In Print preview, Access must fully "render" *every single image on the report*
So going into each subreport then going into each image in that subreport will use a *lot* of system resources.

This is why "Report View" is even worse, as it seeks to just show accurate raw data.
Report view gives relatively little emphasis on "graphical" elements...
(It also ignore most common vba code, and does not show page breaks, ...etc)

You can try running this report on a machine with more memory...
Or try simplify the report.

Does this report really require *Every* main Report Record?
Try filtering the report for fewer records...
For example:
One Customer, Many Orders, One order with many products, ...and a picture for each product.
Does this really need to be a report for *Every* customer?
I would try to create a filter to select one customer at a time, for the report,
or go further and just filter for one Order.

JeffCoachman
0
tonewellAuthor Commented:
Thanks for your thoughts Jeff.  I have not abandoned this question; just had other things to do for a awhile.

Access reports no doubt were never intended to be used the way that this one is used.  However, this report worked perfectly well for years under Access 2003.  The problems started only on conversion to Access 2010.

I tested this application under Access 2010 a couple of months ago, and passed it: I did not notice any dropped graph-images back then.  But back then I was using an older, slower machine with less memory (2GB compared to 3GB currently).  

Now note that the report in question has 44 pages and well over 100 graph- and table-images (jpgs).  Under Access 2010 this report loads in less than 10 seconds; if the "go to last page" arrow is then clicked, it takes just 5 seconds to show this.  I do not have comparable times available for this report under Access 2003, but I think that it ran much slower under that version of Access.

My conclusion: the report is running too fast; whatever software is retrieving all those jpg's is not keeping up.  I'm thinking that maybe I can fix this problem by slowing computer down during the report generation process.  Do you (or other experts) know of a way to do this?  Redesigning the application to work a different way is not an option.
0
Jeffrey CoachmanMIS LiasonCommented:
Any code on this report...?

You may be able to workaround this issue by using a few strategically placed "DoEvents" in the code...
http://support.microsoft.com/kb/118468
0
tonewellAuthor Commented:
This problem is still not solved.

I had already tried placing "DoEvents" commands in the subreports displaying the problem, but this did not help.  (Unfortunately the problem seems to occur towards the end of pages with 3 or 4 images on them - and it is not possible to tell Access to slow down towards each page-end.)

In a previous post I speculated that the problem may be caused by the system not keeping up the supply of linked jpg's from disk or network.  I have since tried running my report with subreports using embedded images.  The problem persists regardless of whether images are linked or embedded.

I am not sure what else to try.
0
Jeffrey CoachmanMIS LiasonCommented:
You can try using the "attachment" datatype in Access 2007 and newer format databases...

You can also try exporting the report to a PDF, then viewing the PDF

Finally try removing any "Page x of y" controls in the page footer.
0
tonewellAuthor Commented:
I have had to put this question aside for a time.  The problem is still not resolved.  

I have tried exporting the report to a PDF; this makes no difference, the problem persists.

I have not yet tried the other two suggestions in Jeff's last comment.  My company will soon upgrade from Windows XP to Windows 7; before taking further action I want to see if this problem disappears under Windows 7.  

EE may wish to leave this question open until I have something further to report.
0
Jeffrey CoachmanMIS LiasonCommented:
Following the last post, you have 21 days until the system starts alerting you of an Open question.

I am certainly in no rush, ...as I too want to see what resolves this issue...

;-)

Jeff
0
tonewellAuthor Commented:
Our company has since upgraded to Windows 7.  So far the problem has not recurred.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tonewellAuthor Commented:
The problem was not solved any other way
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.