Condition with NOT EXIST

[syedmca]

Hi,

I need to generate report with condition like


Select Distinct Emp_number,Emp_hiredate,Division_id from Employee E where designation=' sales representative'
AND (
NOT EXISTS (
Select address from address A where A.emp_hiredate= E.emp_hiredate
AND ( A.File_number IN ( 'SO','DO') OR FLAG ='y' )
and NOT EXISTS (
select address from shipment B
where A.emp_hiredate= B.emp_hiredate
AND B.flag='Y'.


I am new to crystal report any idea how to place this condition with NOTEXISTS in crystal reports .

 

[lbass]

You could paste this query into the 'Add command' area at the top of your table list in the database expert. Then use the command as your datasource.

-LB