SAP Knowledge Base Article - Public

1576782 - To determine duplicate record count in Cystal Reports

Symptom

If there are 2 Assets for a user then exception is 1 and if the assets are 3 then exception is 2.

Environment

  • Crystal reports XI
  • Crystal reports XI R2
  • Crystal reports 2008

Resolution

  1. To get the resolution for the above symptom we have to write two formulas:
  2. We have to create running total  to get the field count for each user.
  3. Create a formula which will count all the fields for an user runningtotal>1
  4. Count1:=
    Whileprintingrecords;
    NumberVar a;
    If Runningtotal1>1 then a:=a+1;



Keywords

determine duplicate record count. duplicate records. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports all versions