Answer Posted / anuragrajverma

There are eight report triggers.
Global triggers called the Report Triggers :
(1) Before Parameter Form
(2) After Parameter Form
(3) Before Report
(4) After Report
(5) Between Pages
Other Triggers :
(1) Validation Triggers
(2) Format Triggers
(3) Action Triggers
/*******************************/
(1) Before Parameter Form
Fires before the Runtime Parameter Form is displayed. From
this trigger, you can access and
change the values of parameters, PL/SQL global variables,
and report-level columns. (Note : If the
Runtime Parameter Form is suppressed, this trigger still
fires. Consequently, you can use this trigger
for validation of command line parameters).
(2) After Parameter Form
Fires after the Runtime Parameter Form is displayed.
Fromfires. Consequently, you can use this trigger for
validation of command line parameters or other data).
(3) Before Report
Fires before the report is executed but after queries are
parsed and data is fetched.
(4) Between Pages
Fires before each page of the report is formatted, except
the very first page. This trigger can be
used for customized page formatting. (Note : In the
Previewer, this trigger only fires the first time that
you go to a page. If you subsequently return to the page,
the trigger does not fire again.)
(5) After Report
Fires after you exit the Previewer, or after report output
is sent to a specified destination, such
as a file, a printer, or an Oracle*Mail userid. This
trigger can be used to clean up any initial processing
that was done, such as deleting tables. Note, however, that
this trigger always fires, whether or not
your report completed successfully.
(6) Validation Triggers
Validation Triggers are PL/SQL functions that are executed
when parameter values are
specified on the command line and when you accept the
Runtime Parameter Form. (Notice that this
means each Validation Trigger may fire twice when you
execute the report). Validation Triggers are
also used to validate the Initial Value of the parameter in
the Parameter property sheet.
(7) Format Triggers
Format Triggers are PL/SQL functions executed before the
object is formatted. The trigger can
be used to dynamically change the formatting attributes of
the object.
(8) Action Triggers
Action Triggers are PL/SQL procedures executed when a
button is selected in the Previewer.
The trigger can be used to dynamically call another report
(drill down) or execute any other PL/SQL.

difference between global n context sensitive segments?

2190

---

if u want to delete all these detail block etc what will happen in form

1460

---

How to create Drill down report?

1680

---

What are the various configuration files that are used by oracle forms?

546

---

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4057

---

---

What is the difference between flex mode and confined mode?

514

---

what is difference between group above and group left report

3181

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1628

---

Explain master-detail relationship with some examples.

571

---

why the Ctl file u put only in bin folder why not in other folder

1586

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

796

---

how report can be generated if we have the database designed in oracle 10g?

1441

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1588

---

What is a matrix report and how many minimum groups are required to prepare the same?

531

---

how to send file attachment from oracle forms

2123

---