Hi,
I am eliminating duplicate rows by using the section expert, selecting the detail section and adding the following formula next to the suppress no drill down option.
((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})
This code eliminates a duplicate row only. Is there a way how I can eliminate both rows from the report if they are identical. The rows were selected through SQL because another field that I am not pulling into crystal has changed and therefore the effdt has changed. I don't want to see either of the rows on the report if rows are identical.
Thanks.
IP Logged
