SubReport-Only last record from detail shows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subreport that when run alone displays all 4 records I need. However
when I place it in the report footer of the Master Report it only shows one
record (that being the last record of the previous detail section). I have
the properties set to Can Grow. In addition I tried placing it in the
description footer to see what would happen. It also showed just one record
there. The record turned out to be the last record of that particular detail
section just above it. Any help would be appreciated. This is perplexing to
me.
 
I'm assuming that the subreport is linked to the master report using the
Parent/Child Link fields. If so, then the subreport will only show data
relevant to the current record in the master report each time the subreport
is run. Placing the subreport in the Report Footer of the master report, the
subreport will run only one time, at the end of the master report's run when
it formats its Report Footer. The last record in the master report will be
the controlling record for the subreport.

You say that the subreport shows what you want it to show when you open it
by itself. If that is the case, then is sounds as if you don't need or want
the Parent/Child Link fields filled in, make sure they're blank and see what
happens.
 
Back
Top