Is it possible to create report to check duplicates?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mansi.kakkar
    Junior Member
    • Jan 2024
    • 15

    Is it possible to create report to check duplicates?

    I would like to create a report to find out if A (Varchar) which is a unique value, is used in other records of the entity or not.
  • yuri
    Member
    • Mar 2014
    • 8440

    #2
    You can find examples on our demo.

    Click image for larger version

Name:	image.png
Views:	123
Size:	10.0 KB
ID:	103491
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment


    • mansi.kakkar
      mansi.kakkar commented
      Editing a comment
      That worked, thanks yuri !
      Also, is there a way to create a report that compares two date values? For example, date A shouldn't be greater than date B. So, I need to create a report to see if there are any records where date A > date B.
  • castigation
    Junior Member
    • Dec 2024
    • 3

    #3
    Ah, so the solution is to create a grid report to count the values and then filter out which have greater than 1 count value.

    Honestly we wouldn't have figured it out ourself, thanks!

    Comment

    Working...