Subreport Missing Data?

  • Thread starter Thread starter HollyH
  • Start date Start date
H

HollyH

I have a report that is based on a reference number and a
week range.

I need the subreport to print out all records for the
indicated reference number AND the week range input by the
operator.

It will print all of the weeks associated with the
reference number, but not for a limited range.

I only get the first or last week of the range I have asked
for when I use a range.

ie.: for reference number 6912037 I can get all of the
weeks associated, but when I ask for weeks 7001 to 7004
(depending on where I put the subreport; details, footer,
header) I only get the first or last weeks information per
page.

I need to get the full range per reference number on each
page. Not separated out.

Any ideas?
 
I think you need to remove a field from the link master child properties. If
you think the field is required in order to filter the subreport, you may
need to a the criteria into the subreport's recordsource query.
 
Hi Duane,

I have tried adding the criteria to the subreport
recordsource query and it then asks for the week range to
be entered twice. Once for the main report and once for
the subreport. This is an effort to avoid the double entry.

Holly
 
That's one of the penalties for using parameter queries. Consider using
references to controls on forms rather than the very limiting parameters.
 
Back
Top