Hi All,
I am fairly new at this, so please hang with me. Details first -
2 tables:
Table1 has employee name and ssn
Table2 has emplyee ssn and event dates (Month, Day, & Year), and the event details.
The base report has the employee name, etc.; while the sub-report has the event details. This subreport could have any number of items from 0 to ???.
I am trying to creat reports that would:
(1) limit the report to an individual ~or~
(2) limit the search to a particular month ~or~
(3) a combination of both the above.
To meet criteria 1, I know I have to pass a parameter to the base report for the individual I am looking for. This I can do.
However to meet criteria 2, how do I pass the parameter to the subreport to limit the data?
And to meet criteria 3, how do I pass BOTH parameters - one to the base report and one to the subreport?
This maybe more of a form question, but I thought since the end product is a report I would try here first.
I am fairly new at this, so please hang with me. Details first -
2 tables:
Table1 has employee name and ssn
Table2 has emplyee ssn and event dates (Month, Day, & Year), and the event details.
The base report has the employee name, etc.; while the sub-report has the event details. This subreport could have any number of items from 0 to ???.
I am trying to creat reports that would:
(1) limit the report to an individual ~or~
(2) limit the search to a particular month ~or~
(3) a combination of both the above.
To meet criteria 1, I know I have to pass a parameter to the base report for the individual I am looking for. This I can do.
However to meet criteria 2, how do I pass the parameter to the subreport to limit the data?
And to meet criteria 3, how do I pass BOTH parameters - one to the base report and one to the subreport?
This maybe more of a form question, but I thought since the end product is a report I would try here first.
