Graph 2000 chart

[ymanchul]

Hi All,
I have an Access Report with an embedded Microsoft Graph 2000 Chart in the detail section of the report. The report has no Data Record Source. The Graph has a SQL statement as the record source (displayed below). The problem is that most times when I preview the report I have to preview it a couple of times before the graph/chart displays the information correctly. Any ideas how I can fix this?

TRANSFORM Sum(Prod.[NET B]) AS [SumOfNET B]
SELECT Prod.DATE
FROM Prod
WHERE ((Prod.DATE)<200208)
GROUP BY Prod.DATE
ORDER BY Prod.[YEAR]
PIVOT Prod.[YEAR];

 

[fr0man]

I had a similar problem with charts. I couldn't find anything about fixing it and I'm convinced it's a bug in Access. We found that it didn't occur on a machine running Windows ME but did occur on every machine running Windows 2000 we tried it on. The best work around I found was to export the report to Snapshot Viewer and print it from there. Kind of a pain, but it displays correctly in Snapshot Viewer even if it's previewing incorrectly in Access.

 

[ymanchul]

Thanks for the info. That actually works well for me because I want to distribute the reports via the snapshot but I didn't want to send out a wrong report and I didn't want to open it 3 or 4 times to be sure it was correct.