Subreport question

[Guest]

I have a report with multiple subreports on it. Sometimes when there is no
data on a subreport it leaves a big blank space on the main report. Is there
a way to make it so the subreports will shift up so that there is no blank
space if one of the subreports has no data and is not showing up.
Here is what is happening

subreport 1
subreport 2

blank - a subreport with no data


subreport 3


blank - a subreport with no data


subreport 4

 

[Rick Wannall]

Open the report in Design View. Open the properties sheet by looking at
properties of any object on the report.

Check the CanShrink and CanGrow properties on the controls on your report.
If you want to compress space on the report when a thing has no data in it,
set it to CanShrink. Be sure to set the report section (presumably Detail)
to CanShrink = yes also.

 

[Rick Wannall]

Open the report in Design View. Open the properties sheet by looking at
properties of any object on the report.

Check the CanShrink and CanGrow properties on the controls on your report.
If you want to compress space on the report when a thing has no data in it,
set it to CanShrink. Be sure to set the report section (presumably Detail)
to CanShrink = yes also.

 

[Guest]

Thanks that worked

 

[Guest]

Thanks that worked