Count number of records with same data

(0) Share

Report

Posted on by crmrsw15

685

Hi,

I have a requirement to create a view that only contains records that don't have duplicates in a specific field.

i.e. a Contract ID field actually has the same ID when the contract is renewed, meaning several records could exist for the same contract ID. I need to create a view that only shows records that do not have duplicate contract IDs.

To do this I would assume I would need to create a rollup field to count this but cannot see how this is possible.

I could obviously do this with SQL via an SSRS report but would like it to be a view instead. Can anyone point me in the right direction?

Thanks,

Richard

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

RE: Count number of records with same data

Hi crmrsw15 ,

you have to create a plugin/custom workflow (on create and update Contract ID field events) which counts all records with same ID and updates all these record with the results (record count).

This way you will filter record with "Record count" = 0.

Please let me know if you solve.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No