Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Subreport graphs not appearing

Posted on 2007-10-17
Medium Priority
Last Modified: 2012-06-27

I'm migrating an App from Access 2002 to Access 2007. I have a number of reports that have one or graphs as subreports. Worked absolutely perfectly in 2002. When run in 2007 some are missing. I can open the subreports on their own and they are perfect, but when included on the main report they disppear. Normally there are two graphs as separate subreports side by side on a landscape report with other data above the graphs. Mostly it is the right hand graph that has disppeared but in some cases both (there are a number of reports built like this.

I have a hunch it is to do with margins, borders, page sizes etc.... Normally if a report gets too big it spills onto two pages - this appears not to be happening. I've checked all properties etc - there no underlying VBA to get in the way.

Any bright ideas to point me in the right direction?


Question by:Kelvin Sparks
  • 2
LVL 14

Accepted Solution

Glenn_Moore earned 2000 total points
ID: 20092589
Try making the subreports larger (from 5 inches to 7 inches) .
LVL 22

Author Comment

by:Kelvin Sparks
ID: 20240294
Didn't solve it, but lead me to the solution, so I'll give you the points. Answer was to delete the subreport & placeit back on the main report exactly as it was. Nothing different, but it reappeared.
LVL 14

Expert Comment

ID: 20240716
Thanks for the grade and the points.

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Implementing simple internal controls in the Microsoft Access application.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question