subreport date parameter problem

[Dcbrown428]

I have a report that has 9 sub-reports inserted. The report and all of the
subreports are based on data parameters (between[start date]and[end date]).
When I choose this report I have to enter the date information multiple times
(one for each subreport!) to open the report. I also have to do this when I
print the report. What am I doing wrong?

 

[Larry Linson]

I have a report that has 9 sub-reports inserted. The report and all of the
subreports are based on data parameters (between[start date]and[end
date]).
When I choose this report I have to enter the date information multiple
times
(one for each subreport!) to open the report. I also have to do this when
I
print the report. What am I doing wrong?

Firstly, I never use parameter queries for reports -- I always use a form to
enter the information and construct either the RecordSource of the Report,
or a WhereCondition argument for a DoCmd.OpenReport. And, almost always, my
Reports and Subreport Controls, or Forms and Subform Controls, are designed
so that I can use the LinkMasterFields and LinkChildFields of the
Subreport/Subform Control to synchronize them.

I could be wrong, but get a "nagging feeling" that there may be some flaws
in the design if you have 9 subreports all based on either the same or
different date spans.

Perhaps, if you would explain in reasonable detail, what you have, and what
you are trying to accomplish, someone could suggest an approach that might
be easier. Oh, and be sure to tell us in what section of your Report you
have these 9 Subreport Controls placed, and whether they are at the same
level, or if some/all of them are embedded in other Subreport Controls.

Larry Linson
Microsoft Access MVP

 

[Dcbrown428]

My database is set up to track the traffic that visit the model homes in
several new housing developments. Daily I keep track of how many are
potential home buyers, how many came with a realtor, how many contracts were
written, etc. I have 6 communities that I am tracking. I have set up
individual reports for each community to keep track of the traffic totals
based on a date parameter and these work great. I also needed a report that
would list (by community) the total for each community for a date range
parameter and then the total of all the communities. The only way I have
figured out to make this work is to create a subreport for each community
(again based on date range parameter) and insert then into the page detail
portion of the report. I also created a subreport to consolidate all the
totals for that date range and inserted that into the report footer. If
there's a better way, I'm open to suggestions, but keep in mind that I'm
probably a novice at best so keep it simple! If I haven't provided enough
detail please let me know what else would be helpful. Thanks!

I have a report that has 9 sub-reports inserted. The report and all of the
subreports are based on data parameters (between[start date]and[end
date]).
When I choose this report I have to enter the date information multiple
times
(one for each subreport!) to open the report. I also have to do this when
I
print the report. What am I doing wrong?

Firstly, I never use parameter queries for reports -- I always use a form to
enter the information and construct either the RecordSource of the Report,
or a WhereCondition argument for a DoCmd.OpenReport. And, almost always, my
Reports and Subreport Controls, or Forms and Subform Controls, are designed
so that I can use the LinkMasterFields and LinkChildFields of the
Subreport/Subform Control to synchronize them.

I could be wrong, but get a "nagging feeling" that there may be some flaws
in the design if you have 9 subreports all based on either the same or
different date spans.

Perhaps, if you would explain in reasonable detail, what you have, and what
you are trying to accomplish, someone could suggest an approach that might
be easier. Oh, and be sure to tell us in what section of your Report you
have these 9 Subreport Controls placed, and whether they are at the same
level, or if some/all of them are embedded in other Subreport Controls.

Larry Linson
Microsoft Access MVP