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 |
#11
|
|||
|
|||
Duplicate Charts
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" wrote: 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 |
#12
|
|||
|
|||
Duplicate Charts
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. -- Duane Hookom Microsoft Access MVP "ngincolorado" wrote: 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" wrote: 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 |
#13
|
|||
|
|||
Duplicate Charts
In the event that anyone finds this thread and is looking for the answer...
Both the main report and a subreport had a level of detail (multiple records) where there should have been only one record. All the detailed information was provided in the subreports and graphs. -- Duane Hookom Microsoft Access MVP "Duane Hookom" wrote: 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. -- Duane Hookom Microsoft Access MVP "ngincolorado" wrote: 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" wrote: 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 |
#14
|
|||
|
|||
Duplicate Charts
Thanks Duane, your help was invaluable.
"Duane Hookom" wrote: In the event that anyone finds this thread and is looking for the answer... Both the main report and a subreport had a level of detail (multiple records) where there should have been only one record. All the detailed information was provided in the subreports and graphs. -- Duane Hookom Microsoft Access MVP |
#15
|
|||
|
|||
Duplicate Charts
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 -- John Whyte "ngincolorado" wrote: Thanks Duane, your help was invaluable. "Duane Hookom" wrote: In the event that anyone finds this thread and is looking for the answer... Both the main report and a subreport had a level of detail (multiple records) where there should have been only one record. All the detailed information was provided in the subreports and graphs. -- Duane Hookom Microsoft Access MVP |
#16
|
|||
|
|||
Duplicate Charts
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. -- Duane Hookom Microsoft Access MVP "JohnW" wrote: 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 -- John Whyte "ngincolorado" wrote: Thanks Duane, your help was invaluable. "Duane Hookom" wrote: In the event that anyone finds this thread and is looking for the answer... Both the main report and a subreport had a level of detail (multiple records) where there should have been only one record. All the detailed information was provided in the subreports and graphs. -- Duane Hookom Microsoft Access MVP |
#17
|
|||
|
|||
Duplicate Charts
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 -- John Whyte "Duane Hookom" wrote: 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. -- Duane Hookom Microsoft Access MVP "JohnW" wrote: 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 -- John Whyte "ngincolorado" wrote: Thanks Duane, your help was invaluable. "Duane Hookom" wrote: In the event that anyone finds this thread and is looking for the answer... Both the main report and a subreport had a level of detail (multiple records) where there should have been only one record. All the detailed information was provided in the subreports and graphs. -- Duane Hookom Microsoft Access MVP |
#18
|
|||
|
|||
Duplicate Charts
Did you read the ACG tip on requerying the chart object?
I found your new post. -- Duane Hookom Microsoft Access MVP "JohnW" wrote: 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 -- John Whyte "Duane Hookom" wrote: 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. -- Duane Hookom Microsoft Access MVP "JohnW" wrote: 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 -- John Whyte "ngincolorado" wrote: Thanks Duane, your help was invaluable. "Duane Hookom" wrote: In the event that anyone finds this thread and is looking for the answer... Both the main report and a subreport had a level of detail (multiple records) where there should have been only one record. All the detailed information was provided in the subreports and graphs. -- Duane Hookom Microsoft Access MVP |
#19
|
|||
|
|||
Duplicate Charts
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 -- John Whyte "Duane Hookom" wrote: Did you read the ACG tip on requerying the chart object? I found your new post. -- Duane Hookom Microsoft Access MVP "JohnW" wrote: 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 -- John Whyte "Duane Hookom" wrote: 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. -- Duane Hookom Microsoft Access MVP "JohnW" wrote: 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 -- John Whyte "ngincolorado" wrote: Thanks Duane, your help was invaluable. "Duane Hookom" wrote: In the event that anyone finds this thread and is looking for the answer... Both the main report and a subreport had a level of detail (multiple records) where there should have been only one record. All the detailed information was provided in the subreports and graphs. -- Duane Hookom Microsoft Access MVP |
|
Thread Tools | |
Display Modes | |
|
|