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. |
#7
|
|||
|
|||
Duplicate Charts
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. |
#8
|
|||
|
|||
Duplicate Charts
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. |
#9
|
|||
|
|||
Duplicate Charts
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 |
#10
|
|||
|
|||
Duplicate Charts
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 |
|
Thread Tools | |
Display Modes | |
|
|