Grouped Report With Repeat Set To Yes

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
 
M

Marshall Barton

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?


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.
 
M

Melissa

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
 

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