Chart/Graph Question

[spyldbrat]

I have a report that is broken into groups. I created a graph and was HOPING that it would create a create graph for each group. Instead it only created a graph using the first groupings data. Is it possible for it to create a graph for each grouping? Also, I have my groupings printing on separate pages. Is it possible for the graph to display on the respective groupings page

[ranman256]

graphs dont really work like reports, the graph data is in the graph,not the report.
You could make form, in it a listbox of the Groups.
The query would read the form and use the selected item in the listbox to show that group's data.
The 'print' button would cycle thru the list, making a graph, 1 at a time , for each Group in the listbox.
either print to printer or to PDF.

[June7]

I have dynamic graphs set with RowSource property as an SQL with a WHERE clause that references a value on the report. Examples:

SELECT M, D, FD, ZD, ZDM FROM GraphProctor WHERE LabNum=[tbxLabNum];
This graph displays in detail section so each record has its own graph.

SELECT [DropNum], CumulativePenMM FROM [dcpfiledata] WHERE [HoleNum] = [Hole];
This graph displays in the Hole group footer section.

Notice that these are not CROSSTAB queries and the graph type used is XYScatter.

[spyldbrat]

Where you have:

SELECT M, D, FD, ZD, ZDM

What does M, D, FD, ZD, ZDM represent? Are these what you what want filter by?