Taking out spacing for between a series of subreports

[Guest]

Hi,

I have a main report and six subreports that I have placed in the Report
footer. They are driven my some data entry forms that contain various
company information. There is a subreport that runs all of the email address
for a company, another that runs all of the computers for a company and a
third that runs all of the phones for a company. I have a master form with a
drop down. I have designed the report so that a user can select a company
and run this master report. It will list all of the phones, emails,
computers etc for a given company. The only problem is that not every
company has information that needs to be in a sub form. For instance, some
companies have an e-mail and computers but not phone data. When I run the
master report there is a big space for where the phone data would be if they
had any. But since they do not, there is a 2 in verticle space in my
report. It would be nice if access would simply move up the next subreport
so that the giant space is not there if there is no data for that subreport.

Can anyone help?

Thanks,

 

[Marshall Barton]

I have a main report and six subreports that I have placed in the Report
footer. They are driven my some data entry forms that contain various
company information. There is a subreport that runs all of the email address
for a company, another that runs all of the computers for a company and a
third that runs all of the phones for a company. I have a master form with a
drop down. I have designed the report so that a user can select a company
and run this master report. It will list all of the phones, emails,
computers etc for a given company. The only problem is that not every
company has information that needs to be in a sub form. For instance, some
companies have an e-mail and computers but not phone data. When I run the
master report there is a big space for where the phone data would be if they
had any. But since they do not, there is a 2 in verticle space in my
report. It would be nice if access would simply move up the next subreport
so that the giant space is not there if there is no data for that subreport.

Set each subreport control and the report footer section's
CanShrink property to Yes.

 

[Guest]

Marshall. I set all of the controls for Can Shrink to Yes for all of the
subreports and the properties of the main report footer but the space is
still there. Any idea what I am doing whrong?

Thanks,

Chuck

 

[Guest]

Marshall,

I set the properties for all of the subreports and the main page footer for
Can Shrink to Yes but the spaces are still there. Any thoughts to what I am
doing wrong?

Thanks,

 

[Marshall Barton]

I set the properties for all of the subreports and the main page footer for
Can Shrink to Yes but the spaces are still there. Any thoughts to what I am
doing wrong?

Gee, the only thing I can think of is that the space are
between the subreport controls. Make sure that the
subreports are very close together vertically and the there
are no other controls next to them. Also make sure that the
sub report controls do not overlap anywhere.