T
Tom
I have a report whose recordsource is a query, it is
grouped on one of the fields in the query. In the footer
for the group I have inserted a graph using three of the
fields from the query as the rowsource of the graph. The
link child and link master fields in my chart are both set
to the grouped field. The force new page field is set
to "after section" in the footer.
The resulting report provides about 10 pages each with
tabular information and a graph for each value in the
group.
The problem is about every third graph (pgs 3,6,9)are
duplicates of the previous graph. The data and the graph
don't match, the pg 3 matches the pg 2 data, etc. Pages
1,2,4,5,7,8,10 are correct.
What causes this and what do I need to do to fix it?
grouped on one of the fields in the query. In the footer
for the group I have inserted a graph using three of the
fields from the query as the rowsource of the graph. The
link child and link master fields in my chart are both set
to the grouped field. The force new page field is set
to "after section" in the footer.
The resulting report provides about 10 pages each with
tabular information and a graph for each value in the
group.
The problem is about every third graph (pgs 3,6,9)are
duplicates of the previous graph. The data and the graph
don't match, the pg 3 matches the pg 2 data, etc. Pages
1,2,4,5,7,8,10 are correct.
What causes this and what do I need to do to fix it?