C
Chip
Hey everyone...
I have queries set up to get the data that I need. They are Parameter
queries and I have a form set up to collect the Parameters (in this
case StartDate and EndDate).
I also set up Reports for each query. I can get each Report to Run
Individually. What I'm not grasping is, how do I get a Master Report
to Run, ask for the Parameters once, Pass these parameters to each
query/report. Ultimately, I want all the Reports to be on one master
report.
Check my logic for me.
I click on Report. The Report OnOpen Event is set to open the Date
Parameters form. I enter the dates I want, click Ok. The Ok Click
Event, passes these dates to the underlying query, which returns the
data it gets to the Report. I can do that without issue.
Where I'm getting messed up is, if I put all these items on one master
report, I have to answer the Date Parameters over and over again for
each queriy/subreport. How do I get it so the Master Report asks for
the dates once, and then it passes the same dates over and over to
each of the subreports.
And while I have you, does my Master Report have to include anythign
at all? I've read you have to have some link between the Main Report
and all the sub reports. What defines a link? I would like my Master
to include basically nothing (aside from maybe the date the report was
produced) and all the meat of the report located in the SubReports...
chip
I have queries set up to get the data that I need. They are Parameter
queries and I have a form set up to collect the Parameters (in this
case StartDate and EndDate).
I also set up Reports for each query. I can get each Report to Run
Individually. What I'm not grasping is, how do I get a Master Report
to Run, ask for the Parameters once, Pass these parameters to each
query/report. Ultimately, I want all the Reports to be on one master
report.
Check my logic for me.
I click on Report. The Report OnOpen Event is set to open the Date
Parameters form. I enter the dates I want, click Ok. The Ok Click
Event, passes these dates to the underlying query, which returns the
data it gets to the Report. I can do that without issue.
Where I'm getting messed up is, if I put all these items on one master
report, I have to answer the Date Parameters over and over again for
each queriy/subreport. How do I get it so the Master Report asks for
the dates once, and then it passes the same dates over and over to
each of the subreports.
And while I have you, does my Master Report have to include anythign
at all? I've read you have to have some link between the Main Report
and all the sub reports. What defines a link? I would like my Master
to include basically nothing (aside from maybe the date the report was
produced) and all the meat of the report located in the SubReports...
chip