Banded Report Formula Problem

[marydn]

Hello All!

I am trying to create a banded report where only the duplicate data in the report is actually banded.

For example, if my report shows customer A twice and customer B only once I want the Customer A data to be high-lighted so that the end-user will know it is a duplicate record.

I am sure there is an easy way to do this, but I cannot figure it out.

Any help is appreciated!

 

[trublumiller]

Format the field you would like to highlight if it is a duplicate. On the border tab, click the conditional format icon next to the background color. your formula will look something like:

if {Contact.Company} = previous({Contact.Company}) then crYellow else crNoColor

Good luck, Kim

 

[synapsevampire]

You might add to that:

if {Contact.Company} = previous({Contact.Company}) or
{Contact.Company} = next({Contact.Company}) then crYellow else crNoColor

This would highlight the original and the following dupes.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[marydn]

That is exactly what I was looking for. Thanks!