Chart does not update consistently in print preview

[rtmdisplayname]

Hello,

Using Access 2K with Microsoft Chart Control 6.0 (SP4) (OLEDB). (Chart class
is MSGraph.Chart.8)

I have a pie chart embedded in the footer of a report using a query for the
row source. The chart does not update consistently in print preview.
Sometimes the chart looks right, other times the chart does not update, and
displays the default legend showing "East", "West", "North". There appears
to be no rhyme or reason
as to when the chart fails to update. If I run the report repeatedly,
sometimes it works, sometimes it doesn't. No discernible pattern.

Any suggestions on how to fix this, or how to force the chart to requery and
repaint itself whenever displaying the print preview?

Thanks in advance!

 

[Duane Hookom]

ACG Soft has some report/chart tips that might resolve this issue at
http://www.groupacg.com/.

 

[fredg]

Hello,

Using Access 2K with Microsoft Chart Control 6.0 (SP4) (OLEDB). (Chart class
is MSGraph.Chart.8)

I have a pie chart embedded in the footer of a report using a query for the
row source. The chart does not update consistently in print preview.
Sometimes the chart looks right, other times the chart does not update, and
displays the default legend showing "East", "West", "North". There appears
to be no rhyme or reason
as to when the chart fails to update. If I run the report repeatedly,
sometimes it works, sometimes it doesn't. No discernible pattern.

Any suggestions on how to fix this, or how to force the chart to requery and
repaint itself whenever displaying the print preview?

Thanks in advance!

Always create the chart first on a form. Then, once it's working, copy
and paste the chart into the report. This avoids the default North,
South, etc data being shown.

You may also have a timing issue.
Code the Format event of whatever section of the report the graph is
in:

Me!OLEUnbound0.Refresh

Where OLEUnbound0 is whatever the actual name is of the chart control
on the report.