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?