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.

What is a canvas in oracle forms?

1115

---

How to create Drill down report?

2185

---

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2204

---

Explain how can you use the same lov for 2 columns?

1181

---

List the different types of columns in oracle reports.

1048

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1209

---

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

2062

---

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

1362

---

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

3043

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2190

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2280

---

Explain the various types of oracle report?

1135

---

What do you understand by lov and how can it be used?

1154

---

What is the difference between bind and lexical parameter?

1119

---

In what situation u create the BPA.

2254

---