ptappeta 0 Newbie Poster

Hi

Hi I have a requirement like this.

We are using xsl top formatt the oracle returned query results in to proper tables . attached is the sample html file generated .

I want this html to behave like following .

if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD, we want the 3 rd column cell to be highlighted in red .
if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD and RUD ,we need 3 rd and 5 th column elements to be highlighted in red .
if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD,RUD and FUD we want 3 rd ,5 th and 8 th columns elements to be highlighted in red .
if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD,RUD,FUD and CVG we want 3 rd ,5 th,8 th and 10th columns elements to be highlighted in red .

coule you please help how can we achive this .

Hi I have a requirement like this.

We are using xsl top formatt the oracle returned query results in to proper tables . attached is the sample html file generated .

I want this html to behave like following .

if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD, we want the 3 rd column cell to be highlighted in red .
if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD and RUD ,we need 3 rd and 5 th column elements to be highlighted in red .
if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD,RUD and FUD we want 3 rd ,5 th and 8 th columns elements to be highlighted in red .
if the column NOTES_ON_CRITICAL_THRESHOLDS contains DDD,RUD,FUD and CVG we want 3 rd ,5 th,8 th and 10th columns elements to be highlighted in red .

coule you please help how can we achive this .

<DIV CLASS='clsInfo'><b><strong><font face= "Calibri" color="green">DDD:Day-to-Day-Difference </font></b></strong> </DIV><DIV CLASS='clsInfo'><b><strong><font face= "Calibri" color="green"><BR>RUD:Return-Universe-Difference</BR></font></b></strong> </DIV><DIV CLASS='clsInfo'><b><strong><font face= "Calibri" color="green">FUD:Forward_Universe_Difference </font></b></strong> </DIV><DIV CLASS='clsInfo'><b><strong><font face= "Calibri" color="green">CVG:Coverage</font></b></strong> </DIV><DIV CLASS='clsInfo'><b><strong><font face= "Calibri" color="green"> </font></b></strong> </DIV><DIV CLASS='clsInfo'><b><strong><font face= "Calibri" color="DC143C">FUNDS THAT ARE  BREACHING CRITICAL THRESHOLD VALUES</font></b></strong> </DIV><BR>
<TABLE><TR><TH class='S_header'>LIST OF FUNDS WITH ISSUES </TH></TR></TABLE>
<html><head><STYLE>
         .S_HEADER {font-weight: bold; font-style: normal; font-family: Calibri; font-size: 9pt; color: #FFFFFF; background-color: #0B6121; padding-top:1px; padding-right:1px; padding-left:1px; border: 1px solid darkgray; }
         .S_ODD_ROWS {font-weight: normal; font-style: normal; font-family: Calibri; font-size: 8pt; color: #000; background-color: #FFFFFF; padding-top:1px; padding-right:1px; padding-left:1px; border: 1px solid darkgray; }
         .S_EVEN_ROWS {font-weight: normal; font-style: normal; font-family: Calibri; font-size: 8pt; color: #000; background-color: #D8D8D8; padding-top:1px; padding-right:1px; padding-left:1px; border: 1px solid darkgray; }
         TABLE {border-collapse: collapse; border-spacing: 0px; border-width: 1px; border-style: outset; border-color: darkgray;}
         </STYLE></head><body><table border="1"><tr><th class="S_header">FUND_CODE</th><th class="S_header">FUND_MANAGER</th><th class="S_header">FUND_CURRENCY</th><th class="S_header">CURR_TRADER_DUR</th><th class="S_header">PREV_TRADER_DUR</th><th class="S_header">DIFF_TRADER_DUR</th><th class="S_header">CURR_CVG</th><th class="S_header">DIFF_CVG</th><th class="S_header">PREV_RU_TRADER_DUR</th><th class="S_header">CURR_RU_TRADER_DUR</th><th class="S_header">FUND_RU_DIFF</th><th class="S_header">PREV_FU_TRADER_DUR</th><th class="S_header">CURR_FU_TRADER_DUR</th><th class="S_header">FU_CVG</th><th class="S_header">NOTES_ON_CRITICAL_THRESHOLDS</th></tr>
<tr class="S_ODD_ROWS"><td>FCNT</td><td>MARTIN</td><td>CAD</td><td>6.935</td><td>0</td><td>6.935</td><td>100</td><td>-100</td><td>0</td><td>0</td><td>6.935</td><td>0</td><td>0</td><td>0</td><td>DDD > .15; RUD > .35; FUD > .45;</td></tr>
<tr class="S_EVEN_ROWS"><td>TAPYSTP1</td><td>FRANCO CASTAGLIUOLO</td><td>USD</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>29.457</td><td>29.497</td><td>-29.497</td><td>29.512</td><td>29.552</td><td>100</td><td>RUD > 7; FUD > 7;CVG < 97;</td></tr>
<tr class="S_ODD_ROWS"><td>TAPYTAC1</td><td>JEFFREY MOORE</td><td>USD</td><td>3.95</td><td>2.044</td><td>1.906</td><td>100</td><td>0</td><td>0</td><td>0</td><td>3.95</td><td>5.101</td><td>6.705</td><td>100</td><td>DDD > .15; RUD > .35; FUD > .45;</td></tr>
</table></body></html>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.