Duplicate Charts

I created a chart to display monthly data. Each month has distinct data that
is reflected in the cart. The chart displays the data properly, but also
displays as many charts as there are months of data.

These duplicate charts are unnecessary. I've not figured out how to print
just one chart without losing the distinct data that it needs to contain.

I've posted before and read other posts with the same problem, but no one
has ever posted a legitimate solution to any of the posts I've seen. This is
incomprehensible. It is such a basic use of a chart I can't imagine why a
solution cannot be prescribed.

In no other software application have I ever run into have charts needing to
prnt themselves over and over. It's not like each individual chart has any
difference.

Please help. Suggestions I've received or read in the past say "check
master/child relationship" or "change record source query". I can't do
either without losing the underlying information needed. And it's not like
the charts are displaying information from other unrelated records. The
chart displays all the information I need. I just need one chart, not exact
duplicate charts in the same quantity as months I'm evaluating.

Thank you!

A report has a record source and a chart has a row source. If the chart is
in the detail section of the report then you will can as many copies of the
report as you have detail records. Every instance of the chart will be
exactly the same unless you have the Link Master/Child properties set or some
criteria in the Row Source to change the chart.

You haven't told use anything about either the record source or the row
source. I am also lost as to what you want displayed. Do you want only one
chart in your report yet multiple detail records? Do you want your chart to
tie to a record or records in your report?

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

I created a chart to display monthly data. Each month has distinct data that
is reflected in the cart. The chart displays the data properly, but also
displays as many charts as there are months of data.

These duplicate charts are unnecessary. I've not figured out how to print
just one chart without losing the distinct data that it needs to contain.

I've posted before and read other posts with the same problem, but no one
has ever posted a legitimate solution to any of the posts I've seen. This is
incomprehensible. It is such a basic use of a chart I can't imagine why a
solution cannot be prescribed.

In no other software application have I ever run into have charts needing to
prnt themselves over and over. It's not like each individual chart has any
difference.

Please help. Suggestions I've received or read in the past say "check
master/child relationship" or "change record source query". I can't do
either without losing the underlying information needed. And it's not like
the charts are displaying information from other unrelated records. The
chart displays all the information I need. I just need one chart, not exact
duplicate charts in the same quantity as months I'm evaluating.

Thank you!

Thank you for your reply. The information is queried from 2 tables, a
customer table and a monthly financial table.

I have it saved as a subreport because there is data queried from other
tables, like product inventory, proposals, etc. also on the report.

All tables are linked by a unique customer ID#, and that is how the
Master/Child properties are linked below is my Chart Row Source for the first
chart:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.NetExpenseperUser) AS [Net Expense per User] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

And the second chart in the same subreport:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.TotalPurchasedMinutes) AS [Total Purchased Minutes],
Avg(BackSummaryQuery.PeakMinutesUsed) AS [Peak Minutes Used] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

Thank you for any suggestions at getting the output to just one chart,
graphing 12 months of data, not 12 charts graphing 12 months of data.

"Duane Hookom" wrote:

A report has a record source and a chart has a row source. If the chart is
in the detail section of the report then you will can as many copies of the
report as you have detail records. Every instance of the chart will be
exactly the same unless you have the Link Master/Child properties set or some
criteria in the Row Source to change the chart.

You haven't told use anything about either the record source or the row
source. I am also lost as to what you want displayed. Do you want only one
chart in your report yet multiple detail records? Do you want your chart to
tie to a record or records in your report?

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

I created a chart to display monthly data. Each month has distinct data that
is reflected in the cart. The chart displays the data properly, but also
displays as many charts as there are months of data.

These duplicate charts are unnecessary. I've not figured out how to print
just one chart without losing the distinct data that it needs to contain.

I've posted before and read other posts with the same problem, but no one
has ever posted a legitimate solution to any of the posts I've seen. This is
incomprehensible. It is such a basic use of a chart I can't imagine why a
solution cannot be prescribed.

In no other software application have I ever run into have charts needing to
prnt themselves over and over. It's not like each individual chart has any
difference.

Please help. Suggestions I've received or read in the past say "check
master/child relationship" or "change record source query". I can't do
either without losing the underlying information needed. And it's not like
the charts are displaying information from other unrelated records. The
chart displays all the information I need. I just need one chart, not exact
duplicate charts in the same quantity as months I'm evaluating.

Thank you!

If you have only one chart control and are getting 12 charts then you either
have the chart in the wrong section of the report or you have too many detail
levels in your report. Does the 12 charts have anything to do with 12 months
in the year? If so, remove the 12 months level.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

Thank you for your reply. The information is queried from 2 tables, a
customer table and a monthly financial table.

I have it saved as a subreport because there is data queried from other
tables, like product inventory, proposals, etc. also on the report.

All tables are linked by a unique customer ID#, and that is how the
Master/Child properties are linked below is my Chart Row Source for the first
chart:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.NetExpenseperUser) AS [Net Expense per User] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

And the second chart in the same subreport:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.TotalPurchasedMinutes) AS [Total Purchased Minutes],
Avg(BackSummaryQuery.PeakMinutesUsed) AS [Peak Minutes Used] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

Thank you for any suggestions at getting the output to just one chart,
graphing 12 months of data, not 12 charts graphing 12 months of data.

"Duane Hookom" wrote:

A report has a record source and a chart has a row source. If the chart is
in the detail section of the report then you will can as many copies of the
report as you have detail records. Every instance of the chart will be
exactly the same unless you have the Link Master/Child properties set or some
criteria in the Row Source to change the chart.

You haven't told use anything about either the record source or the row
source. I am also lost as to what you want displayed. Do you want only one
chart in your report yet multiple detail records? Do you want your chart to
tie to a record or records in your report?

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

I created a chart to display monthly data. Each month has distinct data that
is reflected in the cart. The chart displays the data properly, but also
displays as many charts as there are months of data.

These duplicate charts are unnecessary. I've not figured out how to print
just one chart without losing the distinct data that it needs to contain.

I've posted before and read other posts with the same problem, but no one
has ever posted a legitimate solution to any of the posts I've seen. This is
incomprehensible. It is such a basic use of a chart I can't imagine why a
solution cannot be prescribed.

In no other software application have I ever run into have charts needing to
prnt themselves over and over. It's not like each individual chart has any
difference.

Please help. Suggestions I've received or read in the past say "check
master/child relationship" or "change record source query". I can't do
either without losing the underlying information needed. And it's not like
the charts are displaying information from other unrelated records. The
chart displays all the information I need. I just need one chart, not exact
duplicate charts in the same quantity as months I'm evaluating.

Thank you!

It has everything to do with the months - if there was only 4 months of data
being plotted then there would be only 4 charts displayed (still 3 too many).

I don't understand what you mean by removing the 12 month level. The charts
are on the report as a subreport, so I don't believe location on the report
has anything to do with it. Now, within the subreport I have tried putting
the chart in the report header - that actually succeeds at limiting the
output of the subreport to one chart, but when it is a part of the actual
report I get the duplicate charts again.

"Duane Hookom" wrote:

If you have only one chart control and are getting 12 charts then you either
have the chart in the wrong section of the report or you have too many detail
levels in your report. Does the 12 charts have anything to do with 12 months
in the year? If so, remove the 12 months level.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

Thank you for your reply. The information is queried from 2 tables, a
customer table and a monthly financial table.

I have it saved as a subreport because there is data queried from other
tables, like product inventory, proposals, etc. also on the report.

All tables are linked by a unique customer ID#, and that is how the
Master/Child properties are linked below is my Chart Row Source for the first
chart:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.NetExpenseperUser) AS [Net Expense per User] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

And the second chart in the same subreport:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.TotalPurchasedMinutes) AS [Total Purchased Minutes],
Avg(BackSummaryQuery.PeakMinutesUsed) AS [Peak Minutes Used] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

Thank you for any suggestions at getting the output to just one chart,
graphing 12 months of data, not 12 charts graphing 12 months of data.

You stated:
"I don't believe location on the report has anything to do with it"
Then:
"Now, within the subreport I have tried putting the chart in the report
header - that actually succeeds at limiting the output of the subreport to
one chart"

If it succeeds then I believe I was correct. My other point was to limit
your subreport detail level which means to get rid of the months.

I asked a couple posts back for the "record sources" but you haven't
provided them.
--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

It has everything to do with the months - if there was only 4 months of data
being plotted then there would be only 4 charts displayed (still 3 too many).

I don't understand what you mean by removing the 12 month level. The charts
are on the report as a subreport, so I don't believe location on the report
has anything to do with it. Now, within the subreport I have tried putting
the chart in the report header - that actually succeeds at limiting the
output of the subreport to one chart, but when it is a part of the actual
report I get the duplicate charts again.

"Duane Hookom" wrote:

If you have only one chart control and are getting 12 charts then you either
have the chart in the wrong section of the report or you have too many detail
levels in your report. Does the 12 charts have anything to do with 12 months
in the year? If so, remove the 12 months level.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

Thank you for your reply. The information is queried from 2 tables, a
customer table and a monthly financial table.

I have it saved as a subreport because there is data queried from other
tables, like product inventory, proposals, etc. also on the report.

All tables are linked by a unique customer ID#, and that is how the
Master/Child properties are linked below is my Chart Row Source for the first
chart:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.NetExpenseperUser) AS [Net Expense per User] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

And the second chart in the same subreport:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.TotalPurchasedMinutes) AS [Total Purchased Minutes],
Avg(BackSummaryQuery.PeakMinutesUsed) AS [Peak Minutes Used] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

Thank you for any suggestions at getting the output to just one chart,
graphing 12 months of data, not 12 charts graphing 12 months of data.

Let me clarify. When I view the subreport stand alone after putting it in
the header it did limit to one chart. When the subreport is opened the
actual report it then goes through it's replication - 4 mos = 4 charts, 12
mos = 12 charts.

Are you suggesting I put the subreport (chart) in the report footer/header?

How do I get rid of the months in the subreport detail level without losing
the underlying data that makes the plot points on the chart?

The record source is:

SELECT [BackSummaryQuery].[WorkbookUnitID],
[BackSummaryQuery].[WORKBOOKFINANCIALSBYUNITTABLE_CTGAccountNumber],
[BackSummaryQuery].[DateBilled], [BackSummaryQuery].[UnitAccess],
[BackSummaryQuery].[UnitAdj], [BackSummaryQuery].[UnitDiscount],
[BackSummaryQuery].[UnitEquipm], [BackSummaryQuery].[UnitTaxes],
[BackSummaryQuery].[UnitTotalCharge], [BackSummaryQuery].[UnitTotalCell],
[BackSummaryQuery].[UnitDC], [BackSummaryQuery].[PeakUsageLine1],
[BackSummaryQuery].[PeakUsageLine2], [BackSummaryQuery].[PeakUsageLine3],
[BackSummaryQuery].[PeakUsageLine4], [BackSummaryQuery].[PeakUsageLine5],
[BackSummaryQuery].[PeakUsageLine6], [BackSummaryQuery].[PeakUsageLine7],
[BackSummaryQuery].[PeakUsageLine8], [BackSummaryQuery].[PeakMinutesUsed],
[BackSummaryQuery].[CUSTOMERTABLE_CTGAccountNumber],
[BackSummaryQuery].[CTGAccountName], [BackSummaryQuery].[CustomerCategory],
[BackSummaryQuery].[BillCycleDay], [BackSummaryQuery].[InvoiceCycleDay],
[BackSummaryQuery].[NumberofUsers], [BackSummaryQuery].[NetTotalMRCCharges],
[BackSummaryQuery].[NetExpenseperUser], [BackSummaryQuery].[LongDistanceMin],
[BackSummaryQuery].[LongDistanceCharge],
[BackSummaryQuery].[BillPeriodEndDate], [BackSummaryQuery].[BufferPct],
[BackSummaryQuery].[TotalPurchasedMinutes], [BackSummaryQuery].[Purchased1],
[BackSummaryQuery].[Purchased2], [BackSummaryQuery].[Purchased3],
[BackSummaryQuery].[Purchased4], [BackSummaryQuery].[Purchased5],
[BackSummaryQuery].[Purchased6], [BackSummaryQuery].[Purchased7],
[BackSummaryQuery].[Purchased8] FROM [BackSummaryQuery]

Duane, while my posts may be terse I appreciate your help and time in trying
to figure out a solution for my project.

Nate

"Duane Hookom" wrote:

You stated:
"I don't believe location on the report has anything to do with it"
Then:
"Now, within the subreport I have tried putting the chart in the report
header - that actually succeeds at limiting the output of the subreport to
one chart"

If it succeeds then I believe I was correct. My other point was to limit
your subreport detail level which means to get rid of the months.

I asked a couple posts back for the "record sources" but you haven't
provided them.
--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

It has everything to do with the months - if there was only 4 months of data
being plotted then there would be only 4 charts displayed (still 3 too many).

I don't understand what you mean by removing the 12 month level. The charts
are on the report as a subreport, so I don't believe location on the report
has anything to do with it. Now, within the subreport I have tried putting
the chart in the report header - that actually succeeds at limiting the
output of the subreport to one chart, but when it is a part of the actual
report I get the duplicate charts again.

"Duane Hookom" wrote:

If you have only one chart control and are getting 12 charts then you either
have the chart in the wrong section of the report or you have too many detail
levels in your report. Does the 12 charts have anything to do with 12 months
in the year? If so, remove the 12 months level.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

Thank you for your reply. The information is queried from 2 tables, a
customer table and a monthly financial table.

I have it saved as a subreport because there is data queried from other
tables, like product inventory, proposals, etc. also on the report.

All tables are linked by a unique customer ID#, and that is how the
Master/Child properties are linked below is my Chart Row Source for the first
chart:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.NetExpenseperUser) AS [Net Expense per User] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

And the second chart in the same subreport:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.TotalPurchasedMinutes) AS [Total Purchased Minutes],
Avg(BackSummaryQuery.PeakMinutesUsed) AS [Peak Minutes Used] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

Thank you for any suggestions at getting the output to just one chart,
graphing 12 months of data, not 12 charts graphing 12 months of data.

Either your subreport prints multiple charts in each instance or your main
report has multiple instances of your subreport. Find out which is true and
correct it.

The subreport Record Source has little or nothing to do with the chart Row
Source. You might have only Year values in the subreport Record Source and
have Year and Month in the chart Row Source.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

Let me clarify. When I view the subreport stand alone after putting it in
the header it did limit to one chart. When the subreport is opened the
actual report it then goes through it's replication - 4 mos = 4 charts, 12
mos = 12 charts.

Are you suggesting I put the subreport (chart) in the report footer/header?

How do I get rid of the months in the subreport detail level without losing
the underlying data that makes the plot points on the chart?

The record source is:

SELECT [BackSummaryQuery].[WorkbookUnitID],
[BackSummaryQuery].[WORKBOOKFINANCIALSBYUNITTABLE_CTGAccountNumber],
[BackSummaryQuery].[DateBilled], [BackSummaryQuery].[UnitAccess],
[BackSummaryQuery].[UnitAdj], [BackSummaryQuery].[UnitDiscount],
[BackSummaryQuery].[UnitEquipm], [BackSummaryQuery].[UnitTaxes],
[BackSummaryQuery].[UnitTotalCharge], [BackSummaryQuery].[UnitTotalCell],
[BackSummaryQuery].[UnitDC], [BackSummaryQuery].[PeakUsageLine1],
[BackSummaryQuery].[PeakUsageLine2], [BackSummaryQuery].[PeakUsageLine3],
[BackSummaryQuery].[PeakUsageLine4], [BackSummaryQuery].[PeakUsageLine5],
[BackSummaryQuery].[PeakUsageLine6], [BackSummaryQuery].[PeakUsageLine7],
[BackSummaryQuery].[PeakUsageLine8], [BackSummaryQuery].[PeakMinutesUsed],
[BackSummaryQuery].[CUSTOMERTABLE_CTGAccountNumber],
[BackSummaryQuery].[CTGAccountName], [BackSummaryQuery].[CustomerCategory],
[BackSummaryQuery].[BillCycleDay], [BackSummaryQuery].[InvoiceCycleDay],
[BackSummaryQuery].[NumberofUsers], [BackSummaryQuery].[NetTotalMRCCharges],
[BackSummaryQuery].[NetExpenseperUser], [BackSummaryQuery].[LongDistanceMin],
[BackSummaryQuery].[LongDistanceCharge],
[BackSummaryQuery].[BillPeriodEndDate], [BackSummaryQuery].[BufferPct],
[BackSummaryQuery].[TotalPurchasedMinutes], [BackSummaryQuery].[Purchased1],
[BackSummaryQuery].[Purchased2], [BackSummaryQuery].[Purchased3],
[BackSummaryQuery].[Purchased4], [BackSummaryQuery].[Purchased5],
[BackSummaryQuery].[Purchased6], [BackSummaryQuery].[Purchased7],
[BackSummaryQuery].[Purchased8] FROM [BackSummaryQuery]

Duane, while my posts may be terse I appreciate your help and time in trying
to figure out a solution for my project.

Nate

"Duane Hookom" wrote:

You stated:
"I don't believe location on the report has anything to do with it"
Then:
"Now, within the subreport I have tried putting the chart in the report
header - that actually succeeds at limiting the output of the subreport to
one chart"

If it succeeds then I believe I was correct. My other point was to limit
your subreport detail level which means to get rid of the months.

I asked a couple posts back for the "record sources" but you haven't
provided them.
--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

It has everything to do with the months - if there was only 4 months of data
being plotted then there would be only 4 charts displayed (still 3 too many).

I don't understand what you mean by removing the 12 month level. The charts
are on the report as a subreport, so I don't believe location on the report
has anything to do with it. Now, within the subreport I have tried putting
the chart in the report header - that actually succeeds at limiting the
output of the subreport to one chart, but when it is a part of the actual
report I get the duplicate charts again.

"Duane Hookom" wrote:

If you have only one chart control and are getting 12 charts then you either
have the chart in the wrong section of the report or you have too many detail
levels in your report. Does the 12 charts have anything to do with 12 months
in the year? If so, remove the 12 months level.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

Thank you for your reply. The information is queried from 2 tables, a
customer table and a monthly financial table.

I have it saved as a subreport because there is data queried from other
tables, like product inventory, proposals, etc. also on the report.

All tables are linked by a unique customer ID#, and that is how the
Master/Child properties are linked below is my Chart Row Source for the first
chart:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.NetExpenseperUser) AS [Net Expense per User] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

And the second chart in the same subreport:

SELECT (Format([BillPeriodEndDate],"mmm"" '""yy")) AS Expr1,
Avg(BackSummaryQuery.TotalPurchasedMinutes) AS [Total Purchased Minutes],
Avg(BackSummaryQuery.PeakMinutesUsed) AS [Peak Minutes Used] FROM
BackSummaryQuery GROUP BY (Format([BillPeriodEndDate],"mmm"" '""yy")),
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1) ORDER BY
(Year([BillPeriodEndDate])*12+Month([BillPeriodEndDate])-1);

Thank you for any suggestions at getting the output to just one chart,
graphing 12 months of data, not 12 charts graphing 12 months of data.

How do I find out which is true?

"Duane Hookom" wrote:

Either your subreport prints multiple charts in each instance or your main
report has multiple instances of your subreport. Find out which is true and
correct it.

The subreport Record Source has little or nothing to do with the chart Row
Source. You might have only Year values in the subreport Record Source and
have Year and Month in the chart Row Source.

--
Duane Hookom
Microsoft Access MVP

I think your subreport is breaking down your records by Month or your main
report is breaking down records by month. I don't believe either of these
should be broken down to that detail level. Again, there is no reason to
display month information in the report just because you want something broke
down by month in the chart.

I still don't recall seeing the Record Source SQL of your main and
subreports, which section of the subreport contains the chart, and the Link
Master/Child of the Report/Subreport and Subreport/Chart.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

How do I find out which is true?

"Duane Hookom" wrote:

Either your subreport prints multiple charts in each instance or your main
report has multiple instances of your subreport. Find out which is true and
correct it.

The subreport Record Source has little or nothing to do with the chart Row
Source. You might have only Year values in the subreport Record Source and
have Year and Month in the chart Row Source.

--
Duane Hookom
Microsoft Access MVP