There are five types of triggers in report 6i
1) Before report trigger
2) After report trigger
3) Before Parameter trigger
4) After parameter trigger
5) Between pages trigger
Firing sequence of report trigger
First the before parameter trigger will raise
after firing this trigger parameter form will displayed
after passing parameter after parameter trigger will fire query will parsed & then before report trigger will fired
then if there are number of pages in your report then the between pages report will fired but it will fire between first & second & so on pages but it will not fired in reverse condition
the after reoprt trigger will fire after closing the runtime parameter form is closed.
Bind variables are used in reprot 6i for replacing the single parameter in the select statement
Lexical Parameter are used to replace the where order by .........coditions at run time.
There are three type of columns in the report 6i these are
1) Placeholder Column
2) Formula Column
3) Summary Column
Placeholder column is used to store a value for a variable.
No you can't have the form without canvas
There are five types of canvases these are
1) Stacked Canvas
2) Content Canvas
3)Tab Canvas
4)Horizantal Canvas
5) Vertical Canvas