GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle Apps  >  D2K
Go To First  |  Previous Question  |  Next Question 
 D2K  |  Question 35 of 47    Print  
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?

  
Total Answers and Comments: 6 Last Update: October 18, 2008     Asked by: kumar 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Vishal
 

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 



Above answer was rated as good by the following members:
reddy81
May 04, 2006 09:39:49   #1  
parash_3380 Member Since: May 2006   Contribution: 4    

RE: how many different layouts are available in Report...

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


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
May 19, 2006 10:35:52   #2  
Vishal        

RE: how many different layouts are available in Report...

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


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
June 16, 2006 09:03:33   #3  
Vijay        

RE: how many different layouts are available in Report...

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


 
Is this answer useful? Yes | No
January 04, 2007 01:58:47   #4  
allarajareddy        

RE: How many different layouts are available in Report...

firing seqence

before parameter form trigger

after paramerter form trigger

before report trigger

between page

after report trigger


 
Is this answer useful? Yes | No
June 17, 2008 13:23:38   #5  
pvenkey Member Since: March 2008   Contribution: 2    

RE: 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 lexi
1.Web and Paper layout
2.Web layout
3.Paper layout

Please see the question b4 u r going to answer

 
Is this answer useful? Yes | No
October 16, 2008 01:45:40   #6  
reddy81 Member Since: October 2008   Contribution: 1    

RE: 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 lexi
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

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape