I need to have this as my query in Crystal.
SELECT DISTINCT A.PERSONNUM, A.PERSONFULLNAME FROM VP_DTC_BASESTORE A
WHERE EMPLOYMENTSTATUS = 'Active'
AND HOMELABORLEVELNM4 = 'F'
AND A.PERSONNUM NOT IN
(SELECT DISTINCT B.PERSONNUM FROM VP_DTC_BASESTORE B
WHERE B.DATE BETWEEN fromdate AND todate)
where fromdate and todate are parameters passed into the report.
If I use a SQL Expression, I can't use parameter fields.
I'm using crystal 8. Any help would be appreciated.
SELECT DISTINCT A.PERSONNUM, A.PERSONFULLNAME FROM VP_DTC_BASESTORE A
WHERE EMPLOYMENTSTATUS = 'Active'
AND HOMELABORLEVELNM4 = 'F'
AND A.PERSONNUM NOT IN
(SELECT DISTINCT B.PERSONNUM FROM VP_DTC_BASESTORE B
WHERE B.DATE BETWEEN fromdate AND todate)
where fromdate and todate are parameters passed into the report.
If I use a SQL Expression, I can't use parameter fields.
I'm using crystal 8. Any help would be appreciated.