db Objects and Charts

  • Thread starter Thread starter JK
  • Start date Start date
J

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
 
Does your report have a record source?
What are these properties of your Chart:
Row Source:
Link Master:
Link Child:
 
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
 
If you look at the datasheet of qryLineWorksheetProductTotalsChart, do you
see records?
 
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
 
Back
Top