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;