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

No Data Macro

P: n/a
El
Is there away I can use a no data macro to eliminate the printing of
blank subreports? I have a report that has several subreports and most
of the time the subreports are not needed. Let's say I have a report
with subreports and I want to print page 1 and page 6. When I print
the report all the pages in between are blank. Any suggestions on how
to eliminate the blanks would be great. Thanks!

Jun 5 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Make sure the detail section is set to CanShrink=Yes. Also all the
subreport controls should be CanShrink=Yes. For good measure, make sure
that controls in teh detail section generally are set the same
(CanShrink=yes).
Jun 5 '06 #2

P: n/a
El

Rick Wannall wrote:
Make sure the detail section is set to CanShrink=Yes. Also all the
subreport controls should be CanShrink=Yes. For good measure, make sure
that controls in teh detail section generally are set the same
(CanShrink=yes).


Tried doing this and I still get the blanks. Any suggestions on what
else I can try? Thanks!!

Jun 6 '06 #3

P: n/a
Graphics can also force blank space. Ifyou have a vertical line, a
rectangle, stuff like that.

If you don't have that, and you have all the CanShrink's in the universe set
to yes, including on the subforms themselves, I'm not sure what else to look
at yet.
Jun 6 '06 #4

P: n/a
El
No graphics. I have page breaks in place, but that shouldn't be a
problem. I thought I could simply just set up a no data macro, but
that doesn't seem to work either.

Rick Wannall wrote:
Graphics can also force blank space. Ifyou have a vertical line, a
rectangle, stuff like that.

If you don't have that, and you have all the CanShrink's in the universe set
to yes, including on the subforms themselves, I'm not sure what else to look
at yet.


Jun 7 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.