I have 2 reports that I need to connect and I know it will probably need a variable setup. It has been a really long time since I've need to do it and I just a blank.
The main report pull the payroll check detail for a "specific check date". The second report totals the YTD gross payroll for the employee at the time of the "specific check date" using sums from 01/01/13 to the check date.
I need to connect (I guess by subreport) and have a shared variable that I can then put that YTD Gross Payroll on the line with the check. The common field in the 2 reports is the employee ID number.
Can someone help me get started with this?