Skip to Content
author's profile photo
Former Member

Highlighting Duplicates Not In Adjacent Rows

I have a sales report which lists Salespersons and is grouped by state. I know how to highlight the items when they are in the same state (and so are in adjacent rows).

However, sometimes there are salespersons who work in different states and, so, may be listed on the report more than once, but not in adjacent rows.

How would I go about highlighting them?

TIA

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Apr 29, 2011 at 11:15 PM

    Hi

    Have you tried using Highlight Expert ? You can highlight conditionally.

    Hope this helps

    Sastry

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      It will not be that slow unless you have over 1000 sales men as an array is limited to 1000 elements.

      But as you point out it will not highlight the first instance of a duplicated salesman.

      The only other alternative is to run a hidden sub report in report header which counts salesmen entries and then build a shared array holding the duplicated sales men, and then high light based on checks against that array.

      Ian