Displaying blank space when no data in subreport

T

Taz

I have a main report with 4 subreports. When a subreport has no data, it
displays a blank space on the report. How can get rid of the blank space?
TIA.
 
M

Marshall Barton

Taz said:
I have a main report with 4 subreports. When a subreport has no data, it
displays a blank space on the report. How can get rid of the blank space?
Click to expand...


Set BOTH the subreport control's and its section's CanShrink
property to Yes.
 
M

Marshall Barton

Taz said:
That is not showing as an option.
Click to expand...


Then you are looking in the wrong place. Just click once on
the subreport **control** on the main report.

Don't forget to set it for the section as well.
 
D

Duane Hookom

I just checked again and a subreport control does have both Can Grow and Can
Shrink properties.

If you can't see them, you are probably looking in the wrong place.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How to prevent subReport from breaking across pages? 1
Subreport with no records 8
Suppress Blank Subreports 2
SubReport Problem 1
SynNeed to account for null values in subreports 2
Display message for blank subreport 1
Subreports with blank pages 7
Subreport behind report data 2

Top