Charts not printing in report

I have created a survey database. I now need to create a report that
has two bar charts for each record (the charts need to change with
each record). I was able to do this successfully on a form. However,
when I try to duplicate this process in a report, it doesn't work,
i.e., the charts display as blank boxes or don't display at all. I am
using the exact same Row Source and Link Child/Master fields info as
on the form. I have tried creating the charts for the report using
the wizard and also pasting them from the form but I get the same
results -- blank charts.

I also tried adding the VB language that I've seen posted at many
forums to the On Print event. This had no effect.

I can, of course, just print the form, but it does not allow me the
grouping and page breaks that I need from a report. I have searched
unsuccessfully just about every online forum in an attempt to find
someone with this same problem. IT has informed me that it is not a
printer problem.

Any thoughts or suggestions you have would be greatly appreciated.

Thanks.

You need a reference to the Microsoft Graph version number Object Library
included in your VBA references. In the VBA editor, Tools, References, then
look down the list and include it.
--
Dave Hargis, Microsoft Access MVP


"?" wrote:

I have created a survey database. I now need to create a report that
has two bar charts for each record (the charts need to change with
each record). I was able to do this successfully on a form. However,
when I try to duplicate this process in a report, it doesn't work,
i.e., the charts display as blank boxes or don't display at all. I am
using the exact same Row Source and Link Child/Master fields info as
on the form. I have tried creating the charts for the report using
the wizard and also pasting them from the form but I get the same
results -- blank charts.

I also tried adding the VB language that I've seen posted at many
forums to the On Print event. This had no effect.

I can, of course, just print the form, but it does not allow me the
grouping and page breaks that I need from a report. I have searched
unsuccessfully just about every online forum in an attempt to find
someone with this same problem. IT has informed me that it is not a
printer problem.

Any thoughts or suggestions you have would be greatly appreciated.

Thanks.