left outer join is working in bex, but not in crystal reports

good morning ladies and gentleman,

i have created a bex query that shows all employees from the master data table and links to the cats table to show absence hours...

in bex, all employees are showing and some of the employees have hours showing for sick time. this is known as a left outer join.

i have created a report in crystal with this bex query and it does not show rows from the master data that do not have a link to the cats table. only the rows that have a link to the cats table are showing up. (this is compared to a inner join)

the reason i need the master data from the employee table is that the users want to divide the total hours off(sick time) per department by the total employees in that department.

here is the sql query from crystal that was created automatically when i used the bex query to created the crystal report.

SELECT {Measures.4J8L2TQJ3P517ISQ1R4Y8UZ36, Measures.4J9PY3UANRIW2HW15YSOED92A, Measures.4J9TLIO0NDQROSA2YONCW6HB6}

ON COLUMNS,

NON EMPTY

CROSSJOIN(0EMPLOYEE.LEVEL01.MEMBERS, 0EMPLOYEE__0COMP_CODE.LEVEL01.MEMBERS)

DIMENSION PROPERTIES 0EMPLOYEE.50COMP_CODE, 0EMPLOYEE.50MAST_CCTR ON ROWS

FROM ZCATS_MC1/ZZCATS_MC1_Q001C

SAP VARIABLES 0I_DAYS INCLUDING 0CALDAY.20100502 : 0CALDAY.20100903

any thoughts?

thanks,

erik