Toad World® Forums

How to set the font color based on Data results return from query..


#1

My question is how can I do the below in straight SQL or Using Toad Report Builder for Oracle. To make

Start Date : 06/08/2015 : I want to change the font color based on the below sample pulled from Oracle report builder:

if (:crsched_date < trunc(next_day(sysdate - 1, ‘THU’)))

then

srw.set_text_color(‘red’); – The SRW.SET_TEXT_COLOR is what I’m looking for in Toad SQL Oracle.

                                             The command/function to do this in Toad SQL Oracle or in the Toad Report  

                                             Builder is what I’m having problems with. 

srw.set_font_weight(srw.bold_weight);

srw.set_font_style(srw.plain_style);

end if;

if (:crsched_date = trunc(next_day(sysdate - 1, ‘THU’)))

then

srw.set_text_color(‘darkgreen’);

end if;

if (:crsched_date > trunc(next_day(sysdate - 1, ‘THU’)))

then

srw.set_text_color(‘blue’);

srw.set_font_style(srw.plain_style);

end if;

return (TRUE);

end;


#2

I also having the same problem.