Keeping Group Together

  • Thread starter Thread starter Dwight
  • Start date Start date
D

Dwight

First ~ Thanks Fredg for previous reply

On my report I have serveral sub-reports. Two of the sub
reports cannot span across different pages. If all the
records cannot fit on the same page, I need the entire sub-
report to print on the next page. I thought the answer
was in the "KeepTogether" property for groups, but I am
not having any success with it. I have tried several
different settings.

The table consists of:
SSN
Award
AwardOrder

Report Name:
rptResume

Sub-report Name:
rptAward


Does anyone have any ideas??

Thanks in advance!

Dwight
 
Dwight said:
On my report I have serveral sub-reports. Two of the sub
reports cannot span across different pages. If all the
records cannot fit on the same page, I need the entire sub-
report to print on the next page. I thought the answer
was in the "KeepTogether" property for groups, but I am
not having any success with it. I have tried several
different settings.

The table consists of:
SSN
Award
AwardOrder

Report Name:
rptResume

Sub-report Name:
rptAward
Click to expand...


Group KeepTogether applies to the entire group, i.e. the
Header, all the details, and the footer.

Presumably you have the two subreports in the detail section
so a group on the SSN or Award fields won't do what you
want.

You can use a section's KeepTogether to try to keep a single
record's detail from being split across two pages. The
trick here is to place the regular data, one subreport and
the other subreport each in their own section. This is
easily done by creating a low leverl group with header and
footer sections on the data record's primary key (which you
didn't mention in your post). This artificial group will
print all three sections for every detail record in the
report's record source table/query but you can control which
of the sections you want to keep together.
 
Back
Top