Pass a filter from report to subreport

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

HollyH

Third times a charm, right...


I have a report where I make
[week] like [enter period number] & "*"

weeks are the period plus 1, 2, 3, or 4

When I link the field [week] in the subreport, I only get
the entries for the first week that shows up. ie. If there
is an entry for week 1 only the week 1 entries show even if
there are week 3 entries.

I need all of the entries for the period (all four weeks)
to show.

When I take the subform data and place it directly into the
report it works fine.

Does anyone have an idea?
 
Hi Holly.
You do not give much repoert as to how your report is
setup.
I assume you have a group by the period in your main
report, and the main repoert has date for each of the
periods. Than you have a subreport in the footer for the
period group, when you run the report the subreport should
print for each period in your main report.
Come back with some more detail if this did not help.
Fons
 
The main report is grouped by reference number and week
(like [enter period number] & "*").

Each reference number can have entries for each week. The
weeks are broken out into periods of 4 weeks each. So a
reference can have entries for period 6911-1 and 6911-2, etc.

What I am trying to do is get the subreport to grab all of
the entries for the period entered when the report is opened.

Right now, all I get is the list for the first week there
are entries for. If there are entries for week 1 and 2 I
am still getting only the week 1's.

I hope that helped
-----Original Message-----
Hi Holly.
You do not give much repoert as to how your report is
setup.
I assume you have a group by the period in your main
report, and the main repoert has date for each of the
periods. Than you have a subreport in the footer for the
period group, when you run the report the subreport should
print for each period in your main report.
Come back with some more detail if this did not help.
Fons
-----Original Message-----
Third times a charm, right...


I have a report where I make
[week] like [enter period number] & "*"

weeks are the period plus 1, 2, 3, or 4

When I link the field [week] in the subreport, I only get
the entries for the first week that shows up. ie. If there
is an entry for week 1 only the week 1 entries show even if
there are week 3 entries.

I need all of the entries for the period (all four weeks)
to show.

When I take the subform data and place it directly into the
report it works fine.

Does anyone have an idea?
.
Click to expand...
.
Click to expand...
 
Hi Holly. I do not quite follow what you have here. If
your report is grouped by reference number and week, that
it is critical to know where your subreport is placed (in
which band) and what the link is (reference number or
week). If you wish could you send me a copy of your mdb
so I can take a look at it. If so, put it in a zip file
and send it to (e-mail address removed).
Fons
-----Original Message-----
The main report is grouped by reference number and week
(like [enter period number] & "*").

Each reference number can have entries for each week. The
weeks are broken out into periods of 4 weeks each. So a
reference can have entries for period 6911-1 and 6911-2, etc.

What I am trying to do is get the subreport to grab all of
the entries for the period entered when the report is opened.

Right now, all I get is the list for the first week there
are entries for. If there are entries for week 1 and 2 I
am still getting only the week 1's.

I hope that helped
-----Original Message-----
Hi Holly.
You do not give much repoert as to how your report is
setup.
I assume you have a group by the period in your main
report, and the main repoert has date for each of the
periods. Than you have a subreport in the footer for the
period group, when you run the report the subreport should
print for each period in your main report.
Come back with some more detail if this did not help.
Fons
-----Original Message-----
Third times a charm, right...


I have a report where I make
[week] like [enter period number] & "*"

weeks are the period plus 1, 2, 3, or 4

When I link the field [week] in the subreport, I only get
the entries for the first week that shows up. ie. If there
is an entry for week 1 only the week 1 entries show
Click to expand...
even
if
there are week 3 entries.

I need all of the entries for the period (all four weeks)
to show.

When I take the subform data and place it directly into the
report it works fine.

Does anyone have an idea?
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top