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
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