What are the type of triggers available in Oracle Reports ?

Answer Posted / satbir

There are five types of trigger in Oracle Reports

Before Parameter Form
Fires before the Runtime Parameter Form are displayed. Can
access the PL/SQL global variables, report level columns
and manipulate accordingly.

After Parameter Form
Fires after the Runtime Parameter form are displayed. Used
to validate the parameter values.

Before Report
Fires before the report is executed but after the queries
is parsed and date is fetched.

Between Pages
Fires before each page of the report are formatted, except
the very first page. This page is used to customize page
formatting.

After Report
Fires after the report previewer are exited, or after
report output is sent to a specified destination.

Is This Answer Correct ?    113 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

536


Why oracle forms required?

548


how to send file attachment from oracle forms

2125


can you convert or reverse engineer a fmx back to a fmb file?

688


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1520






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

1688


did u received a single file or multiple files

1598


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

1588


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

619


Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

1848


what is difference between group above and group left report

3187


In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1431


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

1591


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...

1656


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

1805