Charts on reports

[John]

I wish to have a chart on a report but cannot get it to work properly. I am
basing the chart on a query which selects only the records i need out of a
table. For some reason the chart seems to still get its data from the table
and not the query, even though i put the query in the reports control
scource. It seems to then group all the data and makes multiple charts for
each MainID in the table.
Got me bluffed, havent a clue whats going on. Am only new at this!
Any suggestions gratefully accepted,
John

 

[Duane Hookom]

A report doesn't have a "control source". A chart gets its data from its Row
Source property. The only way that a report's record source will influence a
chart's data is if you have set the Link Master/Child properties like you
would a subreport.

 

[John]

Thanks for the reply Duane,
Following on from your reply to my problem, i do have the exact chart in
form view and basically all i want to do is a report with the same chart on
it. i would then include it in a main report as a sub-report, but at the
moment all i am trying to do is get the same chart on a report to start with.

John

 

[Duane Hookom]

You should be able to copy and paste the chart from the form to the report.
If you don't want records in your report, leave the report's Record Source
property blank.