Skip to Content
0
Former Member
Dec 04, 2006 at 11:35 AM

Report program

27 Views

Hi everyone,

I am creating the report program which fetches the duplicate records or fraud records.

Consider PERNR(Personnel ID ) and SSN(Social Security Number) are the fields that is present in the table XXXXXX.

One SSN number can have only one PERNR(which is a unique ID). But if a SSN field value has more than one PERNR value then I have to send that particular details as the fraud record.

So the table XXXXXX may have more SSN number and a particular SSN number may have different PERNR’S. I want to send those details as the duplicate or fraud records in the report output if a single SSN has more PERNR’S.

Help me in making this output .Thanks in advance.