X
XMan
Main report querying Employers with
SELECT * FROM EMPLOYERS;
Subreport quering Employees and Work Locations with
SELECT * FROM EMPLOYEES LEFT JOIN WLOCATIONS ON
EMPLOYEES.EMPLOYEE_ID = WLOCATIONS.EMPLOYEE_ID;
In the main report I link by EMPLOYER_ID between EMPLOYERS and EMPLOYEES
tables.
When I run the report it's asking for input data on EMPLOYER_ID.
Can you see anything I'm doing wrong here. TIA.
SELECT * FROM EMPLOYERS;
Subreport quering Employees and Work Locations with
SELECT * FROM EMPLOYEES LEFT JOIN WLOCATIONS ON
EMPLOYEES.EMPLOYEE_ID = WLOCATIONS.EMPLOYEE_ID;
In the main report I link by EMPLOYER_ID between EMPLOYERS and EMPLOYEES
tables.
When I run the report it's asking for input data on EMPLOYER_ID.
Can you see anything I'm doing wrong here. TIA.