CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Coloring Duplicate records in reports

edited Apr 3, 2013 4:52AM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered

Hi All

    We have field called "ISC ID" in account object and the requirement was to list down all records which have the ISC ID more than once. I managed to get the report using the function COUNT( ISC ID by ISC ID) and filter > 1. I got the correct results as well.

Now the requirement is to color these duplicate records as below

ISC ID

123

123

123

456

456

89

89

 

All 123 should have the same color and then 456 records should have the same color and then 89 records another color. Is this possible ? I should be able to highlight that cell or highlight that row itself. In case you have a solution, please let me know.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center