By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

combining subreports based on conditions

P: n/a
I have a report containing multiple subreports (approximately 37
subreports) that are based on individual queries. The query calls to
only display the subreport if there is valid data in the table (that
the subreport is based on). Because the subreport may not always
appear, there are spaces in between the subreports that do contain
valid data. Is there any way to resize or reformat the main report so
all subreports with valid data follow one right after the other? Any
help would me much appreciated!! I have been stuck with this problem
for quite some time and would love any help!! Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I'm not quite sure how your report sections and the 37 subreports are
arranged, but perhaps simply specifying the CanShrink property of the
SubReport Controls will do what you want.

Larry Linson
Microsoft Access MVP

"Anne" <an***********@yahoo.com> wrote in message
news:22**************************@posting.google.c om...
I have a report containing multiple subreports (approximately 37
subreports) that are based on individual queries. The query calls to
only display the subreport if there is valid data in the table (that
the subreport is based on). Because the subreport may not always
appear, there are spaces in between the subreports that do contain
valid data. Is there any way to resize or reformat the main report so
all subreports with valid data follow one right after the other? Any
help would me much appreciated!! I have been stuck with this problem
for quite some time and would love any help!! Thanks.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.