Highlight duplicates in column table

GorIV

<p><span><span>Hello,</span> <span>tell me how to</span> <span>change the</span> <span>color of the</span> <span>duplicate</span> <span>values in a column</span><span>.</span></span></p>
<p><span><span>Topic <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/31220-highlight-duplicates-in-column-table/'>http://developer.actuate.com/community/forum/index.php?/topic/31220-highlight-duplicates-in-column-table/</a></span></span&gt; <span><span>could</span> <span>not help</span> <span>because</span> <span>of broken</span> <span>file.</span></span></p>
<p><span><span><img src="http://s008.radikal.ru/i305/1602/b9/b1b413b37cb8.png&quot; alt="b1b413b37cb8.png"></span></span></p>

jfranken

<p>Attached is a sample report that illustrates how to highlight a row when there is a duplicate value in a column.  It uses the Classic Models database.  I created it in BRD Pro 3.1.1, so you might get a warning if you try to run it in a different version of the software.  Just click through the warning and the report should run without any issues.</p>
<p> </p>
<p>The code to do the highlighting is in the detail row Highlight rule.  The code highlights all rows in the report that have the same value for Country as one of the previous rows.  There are a lot of duplicates in this set of data so you will see a lot of highlighting.  If three rows have country = "Canada", only the second and third rows with Canada will be highlighted because the first instance is not a duplicate at the time it is created which is when the code runs.</p>
<p> </p>
<p>Regards,</p>
<p>Jeff</p>