Need help with using a bar graph in a report

[Wesley_Dallas]

I have a report that separates information about representatives by manager.
I need the graphs to give a quick summary on a few stats from each rep but
only show for that manager's team and not all information.

For example:

Manager A has RepA, RepB, and RepC under him. Each rep has Aux1, Aux2, Aux3
information which needs to be displayed. My goal is to show Manager A with
his Reps A,B, and C of their Aux1, 2, and 3. Then, under the next manager
Header I want Manager B to show Rep D, E, and F with their Aux1, 2, and 3
information. Etc thru Manager G.

Please help...

 

[Duane Hookom]

This is accomplished using the Link Master/Child properties of the graph
control. The Row Source of the graph must include the appropriate field(s)
and these fields must be bound to controls in the report section containing
the graph.

 

[Wesley_Dallas]

Thank you very much.

I have one more problem...

My graph is measured by % going from -100% to 100% along the y-axis. Problem
is that some of the data goes beyond the 100 or -100 limit and I would want
the graph to cut off at that point instead of bleeding into the report. Is
this possible without changing the scale?

 

[Duane Hookom]

Did you search around the various property dialogs in the graph control to
find the Y scale properties?

 

[Duane Hookom]

Apparently you feel the filtering is not clearing in the report when it is
closed and then opened again. How are you applying the filtering? Is this in
the report's record source query or using the Where Condition of the
DoCmd.OpenReport or other?

Maybe you can provide your code and the SQL view of the report's record
source?