Sunday, February 28, 2016

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:
 

No comments:

Post a Comment