Hello everyone,

Does anyone know what type of formula to write to search for duplicate addresses in a crystal report? We have used the Duplicate Report in Raiser's Edge but we are wanting to search by a constituent code to search for duplicate addresses, something the Duplicate Report in RE cannot do. Specifically, we want to query out our alums and then check addresses for duplicates?  Thank you.

 Dianne Smith

 Dianne,

There may be a way of doing this within Raiser's Edge that I am unaware of (and I would always recommend that first) but a few of my clients use IDLookup to search for duplicates. In your case you would use a query of alums exported to Excel and then feed them back into IDLookup. In IDLookup you can search for matches based on address and then filter them based on constituent code. You can read more about IDLookup and download a fully working version (tied to the sample database) here and see a screencast demo here.

 If you have any questions then please do not hesitate to contact me.

 David

Crystal report is a reporting tool not a querying tool so I do not believe that Crystal would be your best choice for this.  If RE is not doing what you want (I'm still not sure what you need it to do) then you can export to Access and use the duplicate records tool in there or go directly to SQL and write SQL code to do this.