Charts in Reports

[Jamie A Miller]

I am trying to create a chart in a report that will group per my
specifications. Specifically, I am trying to tally responses of evaluations,
based on response (strongly agree, agree, disagree, and strongly disagree),
Workshop ID, Question Number, and Count of Response/Question/Workshop. I can
get the chart to work fine for the overall total, however, I need it to group
by Workshop ID. I cannot get the information to group (even with using the
grouping option) by Workshop ID- all it does is show the same exact chart
multiple times for the various groups. I am trying to figure this out ASAP,
as I need to set this up for my clerical staff before surgery in two days!
HELP.

I have tried looking at the ACG Web site to no avail.

 

[Duane Hookom]

You can use the Link Master/Child properties to filter the chart groups.
This is demonstrated in the sample "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Jamie A Miller]

I think I now have it working, however, for every record that I have in my
query, I get a complete copy of the chart again. Example: For Workshop ID
6, which has 10 lines of data for the record, I get 10 copies of the same
chart.

 

[Duane Hookom]

Either remove the duplicate records from the report's record source or move
the chart to a Group Header or Group Footer section.