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

Dynamic Subreport Size

P: n/a
I have a report with a sub report, and the subreport could have anywhere
from 0 to 4 records in it (most will have zero) I would like to have the
report formatted so there is not a big space between each record if there is
no sub report data for that record. Is there a way (VBA or otherwise) that
I can format the report so that there is just enough space under each record
in the master report to show the associated sub report records, and no extra
space if there are no subreport records for that item?

Thanks.

Steve
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Set the sub report's Can Shrink property to yes.
"Steve Edwards" <ra***********@hotmail.com> wrote in message
news:vp************@corp.supernews.com...
I have a report with a sub report, and the subreport could have anywhere
from 0 to 4 records in it (most will have zero) I would like to have the
report formatted so there is not a big space between each record if there is no sub report data for that record. Is there a way (VBA or otherwise) that I can format the report so that there is just enough space under each record in the master report to show the associated sub report records, and no extra space if there are no subreport records for that item?

Thanks.

Steve

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.