If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Duplicate Charts
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! |
#3
|
|||
|
|||
Duplicate Charts
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! |
#4
|
|||
|
|||
Duplicate Charts
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! |
#5
|
|||
|
|||
Duplicate Charts
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. |
#6
|
|||
|
|||
Duplicate Charts
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. |
Thread Tools | |
Display Modes | |
|
|