How to fix Repeat? 1

[bv0719]

Hello... Having a problem with duplicate records. Found a post referrencing the use of the "previous" command to verify duplicates. I added this formula:

if previous ({cusmas.c_cid}) = ({cusmas.c_cid})
then "repeat" else
{cusmas.c_cid}

to the details section of my report along with another statement to show true/false.

{@pre} = "repeat"

How can I select on the true/false result? Since all data is in the details section this becomes an evaluation time problem. Any thoughts?

Thanks,
BV

 

[bv0719]

Disregard... I figured it out. Had to use the Section expert to supress based on the formula result.

BV

 

[beltmanjr]

So you want to suppress the details section if the data was already displayed?

Just use the formula

previous ({cusmas.c_cid}) = ({cusmas.c_cid})

in the section expert at the details, suppress formula box.

If the outcome is true the details will be suppressed.