Incorrect data in design view

[deepinsleep]

Hey,

Here is the deal. I have created reports using the chart wizard. The data for the report is from a query. The problem im seeing is that once i create the report and save it, it works fine when i open it up and preview it. However when i go into design view. I see all kinds of different data. Nothing related to the query i created. Sometimes the axis show up as east west north, where as i have something totally different. I was wondering if anyone has seen something like this before and how to solve this issue?
Also, when i try to publish the report with MS Word. Nothing happens. Word opens, but the report never shows up. Any ideas?

 

[dhookom]

I create charts first on forms and set them to Enabled and Unlocked. Then view the form and double-click the chart to load the query data. You can then close the chart and go to the design of the form. Copy the chart back to the report.

I don't think charts are exported to Word. Search through Stephen Lebans site for the best info

http://www.lebans.com.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.