Filtering Graphs

[Little Mojo]

I'm trying to filter a graph in a report footer, but not having too much luck
with it.

I've tried setting the link master/child properties, and the chart formats
with no data at all. Have tried programmatically setting the rowsource
property which resulted in errors about doing that after the report formats.
I'm out of ideas.

Any suggestions would really be appreciated. Thanks!

 

[Duane Hookom]

You can use controls on forms to filter graphs in your report. Any method
that would filter a subreport should also filter a graph. A graph control has
a Row Source property while subreports have Record Sources.