Reports and SubReports Spacing

[PeterM]

I have an AC2003 report. That main report (Main) has 4 subreport controls on
it (Sub1-4). Each of the reports associated with the subreport controls may
or may not have data in the corresponding table to report on. The Main
report has the following layout:

Main
- Sub1
- Sub 2
- Sub 3
- Sub 4

When Main runs, if one of the subreports is blank, the area for that
subreport is blank (expected), but if any of the subsequent subreports do
have data, those subreports display in their position.


In the following example, subreport 2 has no data

Example 1
Main:
- Sub1

- Sub 3
- Sub 4

or if subreport 1 and subreport 3 are empty.

Example 2:
Main

- Sub 2

- Sub 4

and so on. My question is: Is there a way to not print a subreport that has
no data AND position the next subreport in it's position?

What I'm looking for

Example 1:
Main
- Sub1
- Sub 3
- Sub 4

Example 2:
Main
- Sub 2
- Sub 4

Thanks in advance for any help you can provide!

 

[Duane Hookom]

You should be able to simply set the Can Shrink property of the subreport
controls to Yes.

 

[PeterM]

Duane...

All of the subreport controls nave Can Grow and Can Shrink already set to
Yes... any other ideas?

 

[De Jager]

I have an AC2003 report. That main report (Main) has 4 subreport controls
on
it (Sub1-4). Each of the reports associated with the subreport controls
may
or may not have data in the corresponding table to report on. The Main
report has the following layout:

Main
- Sub1
- Sub 2
- Sub 3
- Sub 4

When Main runs, if one of the subreports is blank, the area for that
subreport is blank (expected), but if any of the subsequent subreports do
have data, those subreports display in their position.


In the following example, subreport 2 has no data

Example 1
Main:
- Sub1

- Sub 3
- Sub 4

or if subreport 1 and subreport 3 are empty.

Example 2:
Main

- Sub 2

- Sub 4

and so on. My question is: Is there a way to not print a subreport that
has
no data AND position the next subreport in it's position?

What I'm looking for

Example 1:
Main
- Sub1
- Sub 3
- Sub 4

Example 2:
Main
- Sub 2
- Sub 4

Thanks in advance for any help you can provide!

 

[Duane Hookom]

I expect there is some controls to the left or right of the subreports that
doesn't allow the shrinking. If not, then I suggest something is wrong. Try
rebuild the report with the simplest controls and rebuild it bit by bit.

 

[Chris Emery]

Label controls can cause this problem.

I expect there is some controls to the left or right of the subreports that
doesn't allow the shrinking. If not, then I suggest something is wrong.
Try
rebuild the report with the simplest controls and rebuild it bit by bit.

 

[Armen Stein]

I expect there is some controls to the left or right of the subreports that
doesn't allow the shrinking.

Also, any controls that are overlapping, even by the smallest amount,
will prevent shrinking.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com