0 Replies Latest reply: Sep 26, 2013 10:48 AM by Neha_Accy RSS

    FormatTrigger on line is not working in Oracle Reports

    Neha_Accy

      Hi there,

       

      I am using Oracle Reports 6i and trying to format code as follows :

       

      I have three sections of data say a,b,c.

       

      1) If there is no data returned in Section b and c, then I need to print a line just after section a ends.

      2) If there is no data in section c but section a and b have data, then line should not appear after section a, but after section b

      3) If all sections are having data , then line should appear after section c.

       

      Format trigger for after section A

      function B_2FormatTrigger return boolean is

      begin

      declare

      ret_val boolean;

      begin

      ret_val := false;

      if :CS_MATERIAL_TERMS = 0 and :cf_mh_count = 0 then

         ret_val := true;

      end if;

      return ret_val;

      end;

      end;

       

      format trigger after section B

      function B_4FormatTrigger return boolean is

      begin

      declare

      ret_val boolean;

      begin

      ret_val := false;

      if :CS_MATERIAL_TERMS = 0  and :cf_mh_count <> 0 then

         ret_val := true;

      end if;

      return ret_val;

      end;

      end;

       

      format trigger after section C

       

      function B_9FormatTrigger return boolean is

      begin

       

        return (TRUE);

      end;

       

      :CS_MATERIAL_TERMS = is the summary column which defines data in section C

      :cf_mh_count= is the formula column which defines the data in section B

       

      current issue is that.. in some cases the line is appearing after section A, though section B has data

      Please help...

      Thanks.