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  

Subreports



 
 
Thread Tools Display Modes
  #1  
Old October 25th, 2007, 05:19 PM posted to microsoft.public.access.reports
Renee
external usenet poster
 
Posts: 342
Default Subreports

I have a main report that has three different subreports on it, all three
subreports come up fine and have multiple entries in them. But one of the
reports is causing my main report to print a page per entry (eq. if the
subreport has three entries in it then i get three pages of the whole
report), so each page printed shows the same thing minus what is in the group
header.
Can anyone help me to decipher the problem?

  #2  
Old October 25th, 2007, 10:35 PM posted to microsoft.public.access.reports
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Subreports

Renee,
Pretty hard to say... but, have you checked the subreport's detail
section ForceNewPage is set to NONE.
Also, make sure there are PageBreaks in the subreport.

so each page printed shows the same thing minus what is in the group
header.

Not quite sure what you mean by that.
Perhaps a very simple example of what you see now vs. what you want to
see would help.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."


"Renee" wrote in message
...
I have a main report that has three different subreports on it, all three
subreports come up fine and have multiple entries in them. But one of the
reports is causing my main report to print a page per entry (eq. if the
subreport has three entries in it then i get three pages of the whole
report), so each page printed shows the same thing minus what is in the
group
header.
Can anyone help me to decipher the problem?



  #3  
Old October 29th, 2007, 09:12 PM posted to microsoft.public.access.reports
Renee
external usenet poster
 
Posts: 342
Default Subreports

I have chcekd the ForceNewPage and it is set to none.
My subreport called services required shows six entries on it, because it
shows 6 entries my whole main report prints on 6 sheets with each sheet
showing the same information when it should only be printing one sheet. I
have gone through all the properties for my subreports and all three
subreport properties match eachother so I am not sure why the services
required report is making the whole main report print as many pages as
entries. I have also set my link master/child fields. If you have any other
suggestions for me I will be looking forward to them if not I will have to
figure out another way to do this report.
Thank you,
Renee

"Al Campagna" wrote:

Renee,
Pretty hard to say... but, have you checked the subreport's detail
section ForceNewPage is set to NONE.
Also, make sure there are PageBreaks in the subreport.

so each page printed shows the same thing minus what is in the group
header.

Not quite sure what you mean by that.
Perhaps a very simple example of what you see now vs. what you want to
see would help.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."


"Renee" wrote in message
...
I have a main report that has three different subreports on it, all three
subreports come up fine and have multiple entries in them. But one of the
reports is causing my main report to print a page per entry (eq. if the
subreport has three entries in it then i get three pages of the whole
report), so each page printed shows the same thing minus what is in the
group
header.
Can anyone help me to decipher the problem?




  #4  
Old October 29th, 2007, 09:20 PM posted to microsoft.public.access.reports
Renee
external usenet poster
 
Posts: 342
Default Subreports

Also, my group header and grouper footer don't show up on everypage; the
group header on shows up on the first page and the group footer only shows up
on the last page.

"Al Campagna" wrote:

Renee,
Pretty hard to say... but, have you checked the subreport's detail
section ForceNewPage is set to NONE.
Also, make sure there are PageBreaks in the subreport.

so each page printed shows the same thing minus what is in the group
header.

Not quite sure what you mean by that.
Perhaps a very simple example of what you see now vs. what you want to
see would help.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."


"Renee" wrote in message
...
I have a main report that has three different subreports on it, all three
subreports come up fine and have multiple entries in them. But one of the
reports is causing my main report to print a page per entry (eq. if the
subreport has three entries in it then i get three pages of the whole
report), so each page printed shows the same thing minus what is in the
group
header.
Can anyone help me to decipher the problem?




 




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 11:18 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.