Subreport Missing Data?

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?
 
D

Duane Hookom

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.
 
H

HollyH

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
 
D

Duane Hookom

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