Monday 15 July 2013

Report triggers

Report triggers are of five types and their sequence of Execution:


  • BEFORE PARAMETER FORM
  • AFTER PARAMETER FORM
  • BEFORE REPORT TRIGGER
  • BETWEEN PAGES
  • AFTER REPORT TRIGGER

BEFORE PARAMETER FORM: BEFORE PARAMETER FORM will fire before the parameter form is going to open.
Example:
              function BeforePForm return boolean is
begin
  srw.message(100,'before parameter form trigger');
  return (TRUE);
end; 

output:



 AFTER PARAMETER FORM: – AFTER PARAMETER FORM will fire after the parameter form is opened and after passing the parameter.
Example:
               function AfterPForm return boolean is
begin
  SRW.MESSAGE(101,'after parameter form trigger ');
  return (TRUE);
end;

 output:
 

BEFORE REPORT TRIGGER: BEFORE REPORT TRIGGER will fire before fetching the data from database.
Example: 
              function BeforeReport return boolean is
begin
  SRW.MESSAGE(102,'before report trigger');
  return (TRUE);
end;

 output:


BETWEEN PAGES: BETWEEN PAGES will fire when we are moving from one page to another page
Example: 
              function BetweenPage return boolean is
begin
  SRW.MESSAGE(108,'between PAGE trigger');
  return (TRUE);
end; 

output:


AFTER REPORT TRIGGER: AFTER REPORT TRIGGER will fire when ever we are closing the output of the report
Example: 
                function AfterReport return boolean is
begin
  SRW.MESSAGE(102,'after report trigger');
  return (TRUE);
end; 

output:


1 comment:

Unknown said...

Its good post thanks for sharing information