Monday, February 6, 2017

srw.set_foreground_fill_color

SQL> select add_months(trunc(to_date('31-jan-17'),'MM'),-1) from dual;

ADD_MONTH
---------
01-DEC-16

function R_G_ITEMCODEFormatTrigger return boolean is
begin

  -- Automatically Generated from Report Builder.
  if (MOD(:CF_1,2) = 0)
  then
   srw.set_foreground_fill_color('gray20');
    srw.set_fill_pattern('solid');
  end if;

  return (TRUE);
end;


/////

function F_TEL2FormatTrigger return boolean is
begin
    -- Automatically Generated from Report Builder.
  if (:CF_Remain_dt <= 100)
  then
    srw.set_text_color('red');
  end if;
  return (TRUE);
end;


////

function R_G_GUARNOFormatTrigger return boolean is
begin
    if (:CF_remain_dt <=30)
  then
   srw.set_foreground_fill_color('gray20');
    srw.set_fill_pattern('solid');
  end if;
 
  return (TRUE);
end;

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...