A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Duplicate Charts



 
 
Thread Tools Display Modes
  #11  
Old January 17th, 2007, 12:05 AM posted to microsoft.public.access.tablesdbdesign
ngincolorado
external usenet poster
 
Posts: 26
Default 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  
Old January 17th, 2007, 03:27 AM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old January 18th, 2007, 04:50 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old January 18th, 2007, 05:16 PM posted to microsoft.public.access.tablesdbdesign
ngincolorado
external usenet poster
 
Posts: 26
Default 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  
Old October 24th, 2007, 04:56 PM posted to microsoft.public.access.tablesdbdesign
JohnW
external usenet poster
 
Posts: 107
Default 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  
Old October 24th, 2007, 06:20 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old October 25th, 2007, 10:30 AM posted to microsoft.public.access.tablesdbdesign
JohnW
external usenet poster
 
Posts: 107
Default 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  
Old October 25th, 2007, 03:03 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old October 25th, 2007, 06:09 PM posted to microsoft.public.access.tablesdbdesign
JohnW
external usenet poster
 
Posts: 107
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.