can't keep group header w/ 1st detail

D

dkingston

i have a main report that contains 5 subreports.
1 of my subreports contains several sub-subreports.
i am using group headers from the subreports with
the "repeat section" property set to yes to print headings
at the beginning of a subreport and at the top of
subsequent pages of the subreport in the main report.
i can't prevent access from printing a group heading at
the bottom of a page.
i've tried setting the "keep together" option for the
group to "whole group" and to "with first detail" and in
every combination i could imagine (or that someone
suggested in previous postings) and nothing works.
somebody please help. i'm losing my mind.
many many thanks in advance.

please reply via post or to:
d k i n g s t o n (at) j a g l y n n (dot) c o m
 
B

Bill Crawford

Is there a grouping footer on the main report that its printing to?
Something else to consider is that your main report does not need to have a
control source, if your main report is full of unbound calculated fields.
Link the subreports by the grouping/sorting dialog box of the main report.
Ive done this with an invoice report containing 20 subreports.
 
D

dkingston

there is a group footer in the main report w/ a forced new
page before the section. the control source for the main
report is a table containing address info.
is the group footer somehow causing this problem?
 
B

Bill Crawford

HI:

Make a Page Header in the main report for the client info. Make a group
Header in the main report for each subreport, do the same for the sub report
with the children subreports under it to. Don't try to lump all the
subreports into the detail section or one header/footer of the main report.
To make the group headers go to Sorting/Grouping and set each section to
Header = yes, Footer = no, Keep Together ='Whole Group', Group On ='Each
Value'. Set each section header (no footers) property to Can Grow and ,Can
Shrink , and Keep Together (yes to all) and do the same for each subreport
object in the main report. I assume all your subreports are linked to the
table in your main report by some [ID field] so you can group everything by
unique individual client from your database.

help?
 

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