Duplicate Charts

[ngincolorado]

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!

 

[Duane Hookom]

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]

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

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.

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?

 

[ngincolorado]

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.

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

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.

 

[ngincolorado]

The prior emails have the record source code, as well as the row source code.
If you are receptive to it I'd be happy to .zip the file to you and direct
you to the problem I'm encountering.

Nate

 

[Duane Hookom]

Email me directly at Duane at Hookom dot net to get instructions. Don't
email me your file until you hear from me how to do this.

 

[JohnW]

Hi,

I have form based charts and tables and reports as sub-objects
in one report, "Appendix", using. This takes one report
header and nine section headers, no footers or detail section used.

However, I noticed, as I built "Appendix", that a peculiar effect has
happened, which to my, ignorant eye appears to be random. The effect is that
some charts are repeated on the next page, and the following pages, for
several more pages. As they repeat they gradually change vertical height on
the Appendix report's pages. That is, the same chart (or table) repeats on
several following pages but changes height, often on the at first, next page
too tall and, then, getting progressively smaller on the following pages.

I've placed page beaks at strategic points but to no effect. But I don't
really know what's going on: Basically I'm just guessing!!

Do you know what causes this?

Thanks,

John

 

[Duane Hookom]

I am not aware of what is causing your issue. You might want to browse
through ACG Soft at http://www.groupacg.com/ for some common report/graph
issue resolution.

Also, starting a new thread is recommended.

 

[JohnW]

Thanks, Duane.

I did make a post on this as you suggested, so far no responses. Also I did
search ACG etc. but haven't come up with anything.

John

 

[Duane Hookom]

Did you read the ACG tip on requerying the chart object?

I found your new post.

 

[JohnW]

I've had a browse around. Can't seem to find that, Duane. Can you tell me
which discussion group/website it is listed on in ACG, please?

John