How many different layouts are available in Reports6i? What are they?in which sequence , form level trigger will fire? in which sequence, report trigger will fire?how many types of canvas are there in form? what r they?what are bind variables and lexical reference in oracle reports?how many types of colums are there in Reports6i? what are they?what is the purpose of placeHolder column in Report?can u have a form with out a canvas?what is confine mode and flex mode in reports?how do u register report in oracleApps?

Showing Answers 1 - 12 of 12 Answers

there are four different layouts in report 6i

1) Data Model - To define, modify data model (querys)

2) Paper Layout - work area to format report output

3) Paper Design

4) Paper Parameter form

  Was this answer useful?  Yes

Vishal

  • May 19th, 2006
 

There are eight different layout formats :

1. Tabular

2. Form Like

3. Mailing Label

4. Form Letter

5. Group Left

6. Group Above

7. Matrix

8. Matrix with group 

Vijay

  • Jun 16th, 2006
 

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

  Was this answer useful?  Yes

allarajareddy

  • Jan 4th, 2007
 

firing seqence

before parameter form trigger

after paramerter form trigger

before report trigger

between page

after report trigger

  Was this answer useful?  Yes

reddy81

  • Oct 16th, 2008
 

Q:1) totally there r 9 layouts available in reports,in that 8 are predefined another 1 is manual layout.
1.tabular
2.form like
3.form letter
4.group left
5.group above
6.mailing lable
7.matrix
8.matrix with group &
9.layout model
Q 2) form level->block level->item level
Q 3)before parameter form->after parameter form->before report->between pages->after report
Q4)bind variables r used to replace one value at runtime(only numeric)
lexicals r user to replace an entire string at runtime(dynamically) in where clause
bind is prefixed by ":" & lexical is prefixed by "&"
Q5)3 types of columns in reports
placeholder column,formula column,summary column
Q6)place holder column is used as a global variable in reports
used to display the parameter value out of the outerframe
Q7)no
Q8)by default condine mode on.if it is off we can move the child object out of the parent
by default flex mode is off. if it is on when ever child object moves to wards parent
the parent borders stretched automatically
Q9)first develop the report&save(.rdf)&run(.rdx will generate)
move this .rdx into respective path
then connect to app
create executable,give the method ,provide the executable file name as report name with out extn
then create the concurrent program (with parameters if ur report contains) byattaching executables
then create request group attach c.p to group
then create responsibilitu attach group to resp
create user attach resp to user
then user will submit the request in SRS window

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions