What is the diffrence between AFTER PARAMETER TRIGGER and BEFORE REPORT TRIGGER?

Query which has to be run by the report is parsed at the end of AFTER PARAMATER TRIGGER. Hence values that need to be provided for the bind and lexical variables should be assigned in or before this trigger. In BEFORE REPORT TRIGGER, the parsing is already done and changes to the values of these parameters cannot be handled.

After parameter Trigger: It will fire after the parameter form is displayed.here we can do validation on parameter values
Before Report Trigger: It will fire before the report is execured and after the query is parsed and date is fetched.

  2 Users have rated as useful.

  

Login to rate this answer.