db Objects and Charts

[JK]

Using Access 03 I created a chart on a form. The chart only has two fields,
Item Description and Qty Produced (a sum field.) The form works perfectly
when I switch to form view.

With that done I created a new report and copied the chart from the form to
the report. When I try to preview the report the chart is not there. It's
blank. Only one page and it only displays the report header.

I also created a new (blank) report - clicked Insert Chart and again tried
to preview the report but the chart is not there.

I also created a new (blank) report - clicked Insert Object MS Graph and
again tried to preview the report but the chart was once again not there.

Any help would be greatly appreciated.

Jason

 

[Duane Hookom]

Does your report have a record source?
What are these properties of your Chart:
Row Source:
Link Master:
Link Child:

 

[JK]

Report does not have a recordsource.

Row Source:SELECT qryLineWorksheetProductTotalsChart.ItemDescription,
Sum(qryLineWorksheetProductTotalsChart.SumOfAmtCompleted) AS
SumOfSumOfAmtCompleted FROM qryLineWorksheetProductTotalsChart GROUP BY
qryLineWorksheetProductTotalsChart.ItemDescription;

Link Master: None
Link Child: None

Thx for your help on this!

Jason

 

[Duane Hookom]

If you look at the datasheet of qryLineWorksheetProductTotalsChart, do you
see records?

 

[JK]

I do.

And furthermore - I was able to copy a report that already contained a chart
- one that I created a while ago - I copied it and made all of the settings
identical to the one I tried creating with the chart wizard - and it worked.
Everything is the same - one works and one does not. I'll be reinstalling
Office as soon as possible.

I appreciate your help.

Jason