To Remove Duplicate Values

building reports crystal reports
1

Hi,
I had an issue in my report,
For Ex: in the following report the records are repeating
Clinet school fromdate todate height weight
1234 ---- 12/01/2007 13/07/2009 — ----
1234 ---- 12/01/2007 13/07/2009 ----- -----

i only want 1 similar record in my report ,Can anyone please help me to get rid of such duplicate records.

Many Thanks in Advance,
Deep

pdeep (BOB member since 2007-05-31)

2

Hi Deep,

In order to suppress the duplicate records please follow the below-mentioned steps:

  1. Sort your report on “Client” field.
  2. Now go to Report menu>> Section Expert.
  3. Select “Detail” from the section list.
  4. Click X^2 button opposite to supress.
  5. Write this in the formula workshop: {client}=next({client}). Here client is the field name.
  6. Click OK.
  7. Preview the report.

Regards
Manish

cr_manish :india: (BOB member since 2009-07-30)