Sub-report missing last record

[Michael Conroy]

This one is really wierd. I have two sub reports on one main report. Each has
their own recordsource, the main one has none. The problem is the sub report
does not display the last record when in the main report. If I open up just
the sub report, all the records are displayed, let's say ten records. When I
open up the main report I only get nine records. The funny thing is the box
around the sub does not end at nine, it looks like it is creating room for
the tenth record, but it is not displayed. I have checked the visible option
many times, and as I stated, the record is there when just the sub is opened.
There is plenty of room on the report, that is, the records are not at the
bottom of the page. Obviously, the text boxes and groupings are set to grow
and visibility is set to yes. I just don't understand why the sub will show
ten records and when opened by itself yet when included in another report
will always cut off the last one. Using Access 97 if that means anything. As
always, any help would be greatly appreciated.

 

[Marshall Barton]

This one is really wierd. I have two sub reports on one main report. Each has
their own recordsource, the main one has none. The problem is the sub report
does not display the last record when in the main report. If I open up just
the sub report, all the records are displayed, let's say ten records. When I
open up the main report I only get nine records. The funny thing is the box
around the sub does not end at nine, it looks like it is creating room for
the tenth record, but it is not displayed. I have checked the visible option
many times, and as I stated, the record is there when just the sub is opened.
There is plenty of room on the report, that is, the records are not at the
bottom of the page. Obviously, the text boxes and groupings are set to grow
and visibility is set to yes. I just don't understand why the sub will show
ten records and when opened by itself yet when included in another report
will always cut off the last one. Using Access 97 if that means anything. As
always, any help would be greatly appreciated.

Double check that the subreport **control** on the main
report and its section both have their CanGrow property set
to Yes.

 

[Michael Conroy]

Marshall,
All the main report settings are set to grow. I found the problem on the sub
report. The sub has four groups and the detail makes the fifth. Group One was
set not to grow because it should always be one record. The other groups were
set to grow because they should have multiple records. When I changed the
setting on Group One, the last record showed up. It is wierd because it was
growing on all the other records, but not on the last one, or so I thought.
Thanks, I thought I checked all that.