chart blank on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to insert a chart in the footer section of a report to summarize
the data for each RepType. I use the chart wizard and when I view the chart
in the wizard it looks correct. As soon as I print preview the report
nothing shows up at all in the chart, just a blank box except for the chart
title. The RepType is both the child and master link fields.

Pleae help!
 
You may need to add code to requery the chart object.

=== from http://www.groupacg.com/ ====
Add the following Visual Basic code to the On Print event of the section of
the report that contains the Graph object.

On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!TheNameOfYourGraph.Object
objGraph.Refresh
DoEvents
Set objGraph = Nothing
==========================
 
Thanks for the suggestion, but that still didn't work. I think it has
something to do with the linked child and master fields. As soon as I set
those to blank then the chart shows up, but I want the chart to change
everytime the RepType changes.

Thanks!
 
Is the chart in the RepType footer section? If so, bind a text box to RepType
in that section. You can set the text box to invisible.
 
Back
Top