Access subreports do not always show graphs (in .jpg format)
Posted on 2012-03-22
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!