Missing Data in Report

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

HollyH

I have a report that prints the data in two subreports
based on a company specific time period. The time period
is broken out as follows: XXXX-XX The first two numbers
are a year the second two numbers indicate a period and the
last two numbers are the week within the period.

I am filtering using the statement:
[WEEK] Like [Enter Period] & "*"

In the report I am only getting the first week entered.
Ie. if the first entry for 6911 was made in week 1
(6911-01) then weeks 2, 3, & 4 are not showing up even if
there are entries. If the first entry was week 3 (6911-03)
week 4 doesn't show up even if it has entries.

If I move the report to the details section, I get all of
the weeks, but they are broken out. I need them all together.

When I remove the report/subreport link (child/Master)
[WEEK] I get all data including all years, periods and weeks.

I can't figure out why I am not getting all of the weeks
for the entered criteria when the [WEEK] link is in place.

Help
 
Holly,

I am just trying to imagine what is the structure of your
report/subreports. So if the subreport is linked to the main report via
the [WEEK] field, then I guess it means that when you open the report,
you are only seeing the first main report record, i.e. the first WEEK in
the main report's record source, and the subreport records associated
with this. And then to see the next week, you need to go to the next
main report record. Am I right? So are the main report records shown
one per page?
 
Yes. However, what I need to see is all of the WEEKs not
just the first. I need them to total for the period and
what I am getting is a week by week/page by page.

What can I do to get the totals for the period?

Holly
-----Original Message-----
Holly,

I am just trying to imagine what is the structure of your
report/subreports. So if the subreport is linked to the main report via
the [WEEK] field, then I guess it means that when you open the report,
you are only seeing the first main report record, i.e. the first WEEK in
the main report's record source, and the subreport records associated
with this. And then to see the next week, you need to go to the next
main report record. Am I right? So are the main report records shown
one per page?

--
Steve Schapel, Microsoft Access MVP

I have a report that prints the data in two subreports
based on a company specific time period. The time period
is broken out as follows: XXXX-XX The first two numbers
are a year the second two numbers indicate a period and the
last two numbers are the week within the period.

I am filtering using the statement:
[WEEK] Like [Enter Period] & "*"

In the report I am only getting the first week entered.
Ie. if the first entry for 6911 was made in week 1
(6911-01) then weeks 2, 3, & 4 are not showing up even if
there are entries. If the first entry was week 3 (6911-03)
week 4 doesn't show up even if it has entries.

If I move the report to the details section, I get all of
the weeks, but they are broken out. I need them all together.

When I remove the report/subreport link (child/Master)
[WEEK] I get all data including all years, periods and weeks.

I can't figure out why I am not getting all of the weeks
for the entered criteria when the [WEEK] link is in place.

Help
Click to expand...
.
Click to expand...
 
Holly,

It really sounds like the basic design concept of your whole report
needs to be reviewed. On the face of the information you have given so
far, I don't think you should have a subreport at all. Most likely the
best result will be obtained by creating a query that includes all of
the data you want on your report, and using this query as the
recordsource of the report, and use the report's Sorting & Grouping
functionality to arrange your data as required, including showing your
totals and subtotals in the applicable group footer sections.

If you need more help with this, you might need to give much more
specific details regarding your actual data, with examples, and how you
really want the final outcome of the report to look.
 
Back
Top