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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|