(Msg. 1) Posted: Fri Sep 05, 2008 11:31 am
Post subject: Report prints data twice on two different pages Archived from groups: microsoft>public>access>reports (more info?)
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.
(Msg. 2) Posted: Fri Sep 05, 2008 12:33 pm
Post subject: RE: Report prints data twice on two different pages [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 3) Posted: Fri Sep 05, 2008 12:46 pm
Post subject: RE: Report prints data twice on two different pages [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 4) Posted: Fri Sep 05, 2008 7:50 pm
Post subject: RE: Report prints data twice on two different pages [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 5) Posted: Mon Sep 29, 2008 8:26 am
Post subject: RE: Report prints data twice on two different pages [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 6) Posted: Mon Sep 29, 2008 12:30 pm
Post subject: Re: Report prints data twice on two different pages [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 7) Posted: Mon Sep 29, 2008 12:30 pm
Post subject: Re: Report prints data twice on two different pages [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
>
(Msg. 8) Posted: Mon Sep 29, 2008 12:46 pm
Post subject: Re: Report prints data twice on two different pages [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
> >
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2, 3
Page 1 of 3
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other