Skip to Content
0
Former Member
Jun 03, 2009 at 03:16 PM

Suppressing duplicate records in Crystal Reports XI

246 Views

I have a report that is displaying duplicate records. I have tried :

1)

//This formula suppresses the Details line

//when there are duplicate values contained in the fields.

{@fullname} = Next({@fullname}) And

{LV_PICKFROMLIST_BldgFloor.VALUE} = Next({LV_PICKFROMLIST_BldgFloor.VALUE}) And

{EMPLOYEE.U_GRID_LOCATION} = Next ({EMPLOYEE.U_GRID_LOCATION}) And

{EMPLOYEE.U_SECTION_ROOM} = Next ({EMPLOYEE.U_SECTION_ROOM})

which did not work...and

2)

Database\Select distinct records...which did not work

??I put the formula in the Details section - but the data presents in the "Details a" section...should I put the formula there?