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 » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report prints data twice on two different pages



 
 
Thread Tools Display Modes
  #1  
Old September 5th, 2008, 07:31 PM posted to microsoft.public.access.reports
Xfree
external usenet poster
 
Posts: 46
Default Report prints data twice on two different pages

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks
  #2  
Old September 5th, 2008, 08:33 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Report prints data twice on two different pages

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a subreport.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks

  #3  
Old September 5th, 2008, 08:46 PM posted to microsoft.public.access.reports
Xfree
external usenet poster
 
Posts: 46
Default Report prints data twice on two different pages

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a subreport.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks

  #4  
Old September 6th, 2008, 03:50 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Report prints data twice on two different pages

You are somewhat correct. It's more like you have a detail table in your main
report's record source that should not be included.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a subreport.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks

  #5  
Old September 29th, 2008, 04:26 PM posted to microsoft.public.access.reports
Xfree
external usenet poster
 
Posts: 46
Default Report prints data twice on two different pages

Daune,
I am still battling this issue, I have removed fields but I am still
getting the sub-report section printing twice.

Any other ideas?


"Duane Hookom" wrote:

You are somewhat correct. It's more like you have a detail table in your main
report's record source that should not be included.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a sub-report.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks

  #6  
Old September 29th, 2008, 05:30 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default Report prints data twice on two different pages

Mor Likely you need to remove a table from the query rather than fields.

Of course you can use
SELECT DISTINCT ...

and remove all the fields from the tables that are being used in the sub-report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Xfree wrote:
Daune,
I am still battling this issue, I have removed fields but I am still
getting the sub-report section printing twice.

Any other ideas?


"Duane Hookom" wrote:

You are somewhat correct. It's more like you have a detail table in your main
report's record source that should not be included.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a sub-report.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks

  #7  
Old September 29th, 2008, 07:25 PM posted to microsoft.public.access.reports
Xfree
external usenet poster
 
Posts: 46
Default Report prints data twice on two different pages

I tried to remove tables but it kills the report. Now this report has 3 sub
reports in it 2 out of three of the sub reports prints correctly i.e. only
once, just the one sub report is causing me issues of repeating its self on
page 2 of what should be a 1 page report.

"John Spencer" wrote:

Mor Likely you need to remove a table from the query rather than fields.

Of course you can use
SELECT DISTINCT ...

and remove all the fields from the tables that are being used in the sub-report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Xfree wrote:
Daune,
I am still battling this issue, I have removed fields but I am still
getting the sub-report section printing twice.

Any other ideas?


"Duane Hookom" wrote:

You are somewhat correct. It's more like you have a detail table in your main
report's record source that should not be included.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a sub-report.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks


  #8  
Old September 29th, 2008, 08:46 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Report prints data twice on two different pages

Perhaps you should share the record sources of your main report and the 1
subreport giving the problems as well as the Link Master/Child properties.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I tried to remove tables but it kills the report. Now this report has 3 sub
reports in it 2 out of three of the sub reports prints correctly i.e. only
once, just the one sub report is causing me issues of repeating its self on
page 2 of what should be a 1 page report.

"John Spencer" wrote:

Mor Likely you need to remove a table from the query rather than fields.

Of course you can use
SELECT DISTINCT ...

and remove all the fields from the tables that are being used in the sub-report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Xfree wrote:
Daune,
I am still battling this issue, I have removed fields but I am still
getting the sub-report section printing twice.

Any other ideas?


"Duane Hookom" wrote:

You are somewhat correct. It's more like you have a detail table in your main
report's record source that should not be included.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a sub-report.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks


  #9  
Old September 29th, 2008, 09:31 PM posted to microsoft.public.access.reports
Xfree
external usenet poster
 
Posts: 46
Default Report prints data twice on two different pages

I think I may have found the issue a sub report is allowing duplicate records
and I had two records for each of the ID's. When I deleted the duplicate
records the extra page went away. Now all I have to do is figure out how to
fix this new issue.

Thanks all for the help.

"Duane Hookom" wrote:

Perhaps you should share the record sources of your main report and the 1
sub report giving the problems as well as the Link Master/Child properties.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I tried to remove tables but it kills the report. Now this report has 3 sub
reports in it 2 out of three of the sub reports prints correctly i.e. only
once, just the one sub report is causing me issues of repeating its self on
page 2 of what should be a 1 page report.

"John Spencer" wrote:

Mir Likely you need to remove a table from the query rather than fields.

Of course you can use
SELECT DISTINCT ...

and remove all the fields from the tables that are being used in the sub-report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Xfree wrote:
Daune,
I am still battling this issue, I have removed fields but I am still
getting the sub-report section printing twice.

Any other ideas?


"Duane Hookom" wrote:

You are somewhat correct. It's more like you have a detail table in your main
report's record source that should not be included.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a sub-report.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks

  #10  
Old October 2nd, 2008, 03:02 PM posted to microsoft.public.access.reports
Xfree
external usenet poster
 
Posts: 46
Default Report prints data twice on two different pages

I am still unable to resolve this issue here is what I have:

Main form table
Part Certification with the key field of PartCertificationID with a one to
many join to both subtables

Sub form 1 is
PartCertSub with the key field of PartCertSub and the foreign key that joins
the two tables is PartCertificationID
Within this table also it is joined to the Products table by the ProductID
field (many to one)
The Link Master Fields is PartCerificationID and Link Child is
PartCertificationID

Sub form 2 is
CertMaterialSub with the key field of CertMaterialID and the foreign key to
PartCertification table is PartCertificationID
This table also joins with the PourSchedule table (many to one) by way of
the PourScheduleID foreign key.
The Link Master Fields is PartCerificationID and Link Child is
PartCertificationID

The issue starts when I add more than one record in either sub form one or
two. If there is only one record in each of the two sub reports
it prints correctly.


"Duane Hookom" wrote:

Perhaps you should share the record sources of your main report and the 1
subreport giving the problems as well as the Link Master/Child properties.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I tried to remove tables but it kills the report. Now this report has 3 sub
reports in it 2 out of three of the sub reports prints correctly i.e. only
once, just the one sub report is causing me issues of repeating its self on
page 2 of what should be a 1 page report.

"John Spencer" wrote:

Mor Likely you need to remove a table from the query rather than fields.

Of course you can use
SELECT DISTINCT ...

and remove all the fields from the tables that are being used in the sub-report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Xfree wrote:
Daune,
I am still battling this issue, I have removed fields but I am still
getting the sub-report section printing twice.

Any other ideas?


"Duane Hookom" wrote:

You are somewhat correct. It's more like you have a detail table in your main
report's record source that should not be included.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a sub-report.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks

 




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 12:01 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.