Click here to Skip to main content
15,891,253 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
i want make a report and need to know the duplicated values for specific column


how i can change the color of format duplicated this values
Posted

From your input, You can achieve the same in two ways

1. Fetch data from database with some flagging for duplicate values and display in front end on the basis of that flag with your display requirement.

2. Fetch the data from database order by with your value. Build a logic in front end to check the duplicate value and display it accordingly.


Hope this will help you.
 
Share this answer
 
Comments
Member 10875212 10-Jun-14 7:26am    
thanks aLot
but u can tell me more about :
how Build a logic in front end to check the duplicate value and display it accordingly.
Check this small code script


<% If rsUser("yourcol")="Y" Then %>
<TD valign="top" ><font size="1" style="BACKGROUND-COLOR:red" >your Value</font></TD>
<% else %>

<TD valign="top" ><font size="1" style="BACKGROUND-COLOR:green" >your Value</font></TD>

<% end if%>

hope this will help you.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900