Thanks, I created the following statement
NOT((Next({SJ000174.EMPLID}) = {SJ000174.EMPLID} And
Next({SJ000174.LAST_NAME}) = {SJ000174.LAST_NAME} And
Next({SJ000174.FIRST_NAME}) = {SJ000174.FIRST_NAME} And
Next({SJ000174.NATIONAL_ID}) = {SJ000174.NATIONAL_ID} And
Next({SJ000174.LHS_DEPT_DESCR}) = {SJ000174.LHS_DEPT_DESCR} And
Next({SJ000174.LOCATION}) = {SJ000174.LOCATION} And
Next({SJ000174.REG_TEMP}) = {SJ000174.REG_TEMP} And
Next({SJ000174.FULL_PART_TIME}) = {SJ000174.FULL_PART_TIME} And
Next({SJ000174.LHS_CONTRACT_DESCR}) ={SJ000174.LHS_CONTRACT_DESCR} And
Next({@POSITION TITLE}) = {@POSITION TITLE} And
Next({SJ000174.BUSINESS_UNIT}) = {SJ000174.BUSINESS_UNIT} And
Next({SJ000174.DEPTID}) = {SJ000174.DEPTID} And
Next({SJ000174.UNION_CD}) = {SJ000174.UNION_CD})
I am trying to select only rows where any of the field values are different. If all values are the same, exclude the row from the report. Being new to Crystal, I don't know how to set up the Selection Expert with this statement.
IP Logged
