470,636 Members | 1,365 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

Grouped Report With Repeat Set To Yes

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
Nov 13 '05 #1
2 2497
Melissa wrote:
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.

--
Marsh
MVP [MS Access]
Nov 13 '05 #2
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
"Marshall Barton" <ma*********@wowway.com> wrote in message
news:ka********************************@4ax.com...
Melissa wrote:
I have a grouped report that starts a new page at each group. All the fieldlabels for the report are in the group header because there is a subreportin the top part of the report that needs to grow (The subreport can't growin the page header!). Each page holds 21 records. I need the labels on eachpage so I set the Repeat property of the group header to Yes. When a grouphas 42 records, I get two pages of records with the labels at the top. Thisis good! However, because Repeat is set to Yes, I get a third page with thelabels 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 displaythe 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.

--
Marsh
MVP [MS Access]

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Melissa | last post: by
reply views Thread by Corbin | last post: by
6 posts views Thread by ApexData | last post: by
1 post views Thread by regrat | last post: by
1 post views Thread by Korara | last post: by
???
reply views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.