Grouped Report With Repeat Set To Yes

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

I have a grouped report that starts a new page at each group. All the field
labels for the report are in the group header because there is a subreport
in the top part of the report that needs to grow (The subreport can't grow
in the page header!). Each page holds 21 records. I need the labels on each
page so I set the Repeat property of the group header to Yes. When a group
has 42 records, I get two pages of records with the labels at the top. This
is good! However, because Repeat is set to Yes, I get a third page with the
labels at the top but no records for that group. What do I need to do to
have the report not create the third page for that group but rather display
the next group on the third page?

Thanks!

Melissa
 
Melissa said:
I have a grouped report that starts a new page at each group. All the field
labels for the report are in the group header because there is a subreport
in the top part of the report that needs to grow (The subreport can't grow
in the page header!). Each page holds 21 records. I need the labels on each
page so I set the Repeat property of the group header to Yes. When a group
has 42 records, I get two pages of records with the labels at the top. This
is good! However, because Repeat is set to Yes, I get a third page with the
labels at the top but no records for that group. What do I need to do to
have the report not create the third page for that group but rather display
the next group on the third page?
Click to expand...


That third page happens because there is actually some part
of the group to display. It's probably just a little blank
area at the bottom of the last (detail?, group footer?)
section in the group. Locate and remove the unused space.
 
Marshall,

Thank you for responding! You sent me in the correct direction to solving
the problem. I have a subreport in the group footer. The subreport has no
records in this situation. The can shrink property of the subreport control
was set to Yes but the can shrink property of the group footer was set to
No. This was what was causing the third page with the labels at the top but
no records for that group. I set the can shrink property of the group footer
to Yes and the report works correctly now. Thanks again!

Melissa
 
Back
Top