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:
