Skip to Content
Former Member
Mar 26, 2010 at 04:47 PM

Crystal Reports - comparing multiple records


Dear Experts,

I am needing a formula which will allow me to compare multiple records. For example, I will have muliple records for an ID:

1114169 74Y CPT SPIKER PHILLIP AT 4/30/2009 11

1114169 74Y CPT SPIKER PHILLIP PA 1/22/2009 14

I need to be able to compare records and determine if either one of records is less than 12. In this example, the first one would be , so I would want to not print either one on the report.

Any help on this would be very much appreciated