cntrlling vert. spacing on report

  • Thread starter Thread starter perplexed
  • Start date Start date
P

perplexed

Hello,

I have a report that contains several subreports. Each
report represents one person. The subreports contain info
from different tables about that person. The report with
subreports takes up two printed pages. My problem is not
all the subreports will have data for a particular person,
so I suppress them using this in the detail_format subroutine:

If Me!person_awards_subreport.Report.HasData = False Then
Me!person_awards_subreport.Report.Visible = False
End If

However, when I suppress subreports, there are one or more
large blank areas in my report where the subreports would
have been had they contained data. Sometimes, there are
completely blank pages. How do I/can I dynamically move the
subreports that do have data right next to each other on
the report to eliminate the large blank areas and eliminate
the blank pages in my report?

I've seen several metions of setting the can shrink
property for the subreports to yes, but the blank space is
still there.

Thanks in advance for any responses,

Perplexed
 
perplexed said:
I have a report that contains several subreports. Each
report represents one person. The subreports contain info
from different tables about that person. The report with
subreports takes up two printed pages. My problem is not
all the subreports will have data for a particular person,
so I suppress them using this in the detail_format subroutine:

If Me!person_awards_subreport.Report.HasData = False Then
Me!person_awards_subreport.Report.Visible = False
End If

However, when I suppress subreports, there are one or more
large blank areas in my report where the subreports would
have been had they contained data. Sometimes, there are
completely blank pages. How do I/can I dynamically move the
subreports that do have data right next to each other on
the report to eliminate the large blank areas and eliminate
the blank pages in my report?

I've seen several metions of setting the can shrink
property for the subreports to yes, but the blank space is
still there.


Make sure you set the section's (containing the subreports)
CanShrink too.

It's mot necessary to make the subreport invisible. A
subreport with no data will be invisible anyway.
 
I set the detail section in the main report, as well as
each subreport to can shrink = yes with no apparent affect.

perplexed
 
I finally found out where I have to set the can shrink. I
set it in the subreport everywhere I could find it.
However, when I clicked on something in the main report, I
found the subreports listed, and when I displayed the
properties for them, can shrink was no. I changed it and it
works now.

Thanks
 
I'm glad you found it in spite of my poor attempt at
describing where that setting is.--
Marsh
MVP [MS Access]
 
Back
Top