Acc2003 Chart Report - generating new chart based on Grouping

[Guest]

I am trying to create a report that generates a new chart for each Group
summary - either with a sub-report or with filtering of a chart object.

Basically, if this were a manufacturing database, I would want to create a
seperate chart for each individual product. The chart is graphing how many
of each type of defect is occuring summarized by week.

Is this clear enough, or do I need to explain better? Is it even possible,
or do I have to have a seperate graph/report for each filter that I want set?

 

[Duane Hookom]

Not quite sure what you are looking for but you can link Master/Child to
graphs/charts like you can with subreport or subforms.

 

[Guest]

Whenever I try linking the Chart report to the report itself, it returns an
error

"can't build a link between unbound forms."

I was certain you could do a master/child link, but either I'm missing
something, or the installation I have is hose-d - but I did just run the
install myself for Office 2003.

 

[Duane Hookom]

Is the main report bound to a record source of records "for each individual
product".

BTW: you don't need to use the builder button to create these property
values.

 

[Guest]

Yes, the main report was bound to a list of the product categories, that each
individual product would be tied into.

I am guess that the binding problem is with the chart wizard using an
oleUnboundObject frame, but I am not familiar enough with charts to get a
chart using an oleBoundobject frame. Any suggestions? If you have a
step-by-step instruction list for generating a bound chart object that you
have linked into a master/child relationship than I can certainly take that
and run with it - or if that is too much work, if you have a report (fake one
of course) that you can forward to me, I can modify it to suit my needs no
problem.

 

[Guest]

I figured out what I was doing wrong ... the chart wizard will generate the
proper linkage - or rather prompt you what you want linked, if you make the
master report first, then add a chart onto it. I was doing it backwards by
creating the chart first, then wanting to drop it onto a master report and it
doesn't like that. I don't believe it should make a difference one way or
the other, but at least I know what is wrong and how to do it for the next
time I need it.