Reports and SubReports Spacing

  • Thread starter Thread starter PeterM
  • Start date Start date
P

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!
 
You should be able to simply set the Can Shrink property of the subreport
controls to Yes.
 
Duane...

All of the subreport controls nave Can Grow and Can Shrink already set to
Yes... any other ideas?
 
PeterM said:
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!
Click to expand...
 
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.
 
Label controls can cause this problem.

Duane Hookom said:
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.
Click to expand...
 
I expect there is some controls to the left or right of the subreports that
doesn't allow the shrinking.
Click to expand...

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

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top