working out duplicate fields

[johnjrd]

I have the following formula to work out if a record is a duplicate, however i only want both records when they match.

If previous({student.Student Code}) = {student.Student Code} then
"duplicate"
else
"not duplicate"

so at the moment i get the following output
Student code Name
S11111 King not a duplicate
S11111 Smith duplicate

when i suppress based on the formula it will only display the record marked as a duplicate however i need to return both records.

any ideas greatfully accepted

 

[dgillz]

What are you trying to accomplish? Why would you want to suppress the duplicate, yet "return" both records?

More info please. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[johnjrd]

This report is to highlight where the same student code has been used more than once, obviously i only want to display instances where the student code is the same. So i want to supress all the records that arent a duplicate but display the records that have the same student code.

for example

S11110 Brown not a duplicate
S11111 King not a duplicate
S11111 Smith duplicate

so i want to supress the 1st record but display the last two so i can bring to the administrators attention that these records are using the same code.

hope this helps

 

[dgillz]

Create a summary count by student ID, the go to the GROUP Selectiontion formula and enter the following formula:

count({Fieldname},{StudentID})>1

This will have the effect of only showing records with more than one student ID.

Let me know if you haveany questions. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[johnjrd]

thanks thats done the trick

i presume if i want to do more complicated checks that i can create a concatented field (made up of say name,postcode,date of birth) group on it do the summary count and then only select where the count is more than 1

thanks for this