Multiple Records Per page with subform

[David Cruger]

I have a report that should be able to print 2 to 3
records per page. Not much data in each record. However
the report does have a small subform. Without the subform
I get my multiple records per page. As soon as I attached
the subform I only get one record per page and it only
takes up 1/4 of the page. I have other reports using
subforms that print more than one per page. What did I do
wrong with the sub form? There's only a detail section
with 2 fields. No header, footer..etc on the sub form

Thanks;

David D. Cruger
<reply to this newsgroup>

 

[Marshall Barton]

I have a report that should be able to print 2 to 3
records per page. Not much data in each record. However
the report does have a small subform. Without the subform
I get my multiple records per page. As soon as I attached
the subform I only get one record per page and it only
takes up 1/4 of the page. I have other reports using
subforms that print more than one per page. What did I do
wrong with the sub form? There's only a detail section
with 2 fields. No header, footer..etc on the sub form

I hope you're really using a subreport and not a subform.

There are lots of reasons why your detail section is taking
up more space than you intended. You might have set the
details ForceNewPage property, left the detail Height too
big, or made the subreport control to tall without using
CanShrink on both the control and the detail section.

 

[David Cruger]

Marshall;

You are correct, I am using a subreport not a subform.

Not sure what I changed but I went through and made sure
of all options you stated.

ForceNewPage=None
CanShrink=Yes
MainReport Heights=3.6333"
SubReport Height=0.283"

No header/footers for either report.

Something I changed made it start working. I should have
made fewer changes at a time to determine what the cause
was.

Anyway thanks for pointing me in the right direction.

Sincerely,

David D. Cruger
<reply to this newsgroup>