Subreports

G

Guest

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

Al Campagna

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."
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top