Subreport w/no data

[Frank Timmons Jr]

I have a main report that uses several subreports for creating one large
report. This database is for running complaince reports on certain types of
data fields. Each subreport is based on a different complaince query.
There will be instances where one of the subreports do not contain any data
to show.

What is happening now is, when one of the subreports has no data, it is
still reserving a space on the actual report, but that space is completly
blank, not even the subreport header is showing up and the remaining reports
are not aligned correctly on the page because of the 'white space' that is
taken up by the other subreport above it. How can I design this so the
extra space isn't taken up?

Not sure if I explained this clearly, so if more info is needed, please
follow-up with me.

Thanks in advance.

 

[Duane Hookom]

If your subreports are side-by-side or adjacent to other controls, they will
not shrink smaller than the other controls/subreports.