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
|