4 Replies Latest reply: Sep 17, 2013 3:00 AM by user8892037 RSS

    reports 6i. print a text file only when page number = 1

    user453033

      Hello,

      i'd like to print a field text only when page_number = 1

       

      i have a report with for example 100 pages.

      1) first section page 1/40

      2) second section 1/35

      3) third section 1/25

       

      I created a function :

       

      FUNCTION F_numero_page RETURN number IS
           page_num number;
      BEGIN
        srw.get_page_num(page_num);
        RETURN (page_num);
      END;

      in the PL/SQL of my field

      FUNCTION F_28FormatTrigger RETURN BOOLEAN IS
      begin
        IF F_NUMERO_PAGE = 1 then RETURN (TRUE);
        else RETURN(false);
        end IF;
      end;

      the text is printed only on the first page 1/40 (i select 'All Pages' in properties) but not for others sections 1/35 and 1/25 ...

      have you an idea please ?

      thanks