I have a main report with a sub-report for which I need the criteria in the sub based on the Employee ID and Date fields on the main report. I've tried the following to no avail on the criteria line of the sub report query.
I also tried using the OnFormat/OnPrint Events of the Employee Header of the report to pass the Employee and Date fields to a form and use those for criteria. This did not work as well.
Any ideas will be appreciated.