Oracle Reports Questions

1. Oracle report ?
Oracle Report is a tool provided by Oracle Fusion Middleware, which is used to generate reports based on the data stored in the Oracle database. It consists of Oracle Reports Developer, a report designing tool and Oracle Application Server Reports Services.
 

2. Report Level Triggers (Sequence) ?
· Before parameter form  · After parameter form · Before Report · Between Pages · After Report.

 

3. Format Triggers ?
A format trigger is a PL/SQL function executed before an object is formatted. A trigger can be used to dynamically change the formatting attributes of the object.
 

4. When confine mode is “ON” ?
When we set confine mode is “ON” then object cannot be moved outside its parent in the report layout.
 

5. When Flex mode is mode “ON” ?
When we set flex mode is ON then reports automatically resizes the parent when the child is resized.
 

6. Matrix Report?
A matrix is kind of report that looks like an information grid with one row of labels and one column of column. At least 4 groups are required in the data model to prepare a matrix report. One should be cross product group, one cell group and at least two group should be within a cross-product group.
 

7. Lexical & Bind Parameters in Reports ?
&test and  :test      Lexical Parameters performs dynamic SQL query. Use to change the data definition at runtime.

8. Column Mode Property ?
The Column Mode property controls how Report Builder fetches and formats data for instances of repeating frames.

9. Anchors ?
An anchor defines the actual position of an object. Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent. • Implicit (Creates when a report will run)  • Explicit (Anchors you create).

 

10. Placeholder Columns ?
A placeholder is a logical column for which you can conditionally set the datatype and value via PL/SQL or a user exit. Placeholder columns are useful when you want to selectively populate a column with a value.
 

11. Types of parameters ?
1-System Parameters:- Desformate, printjob, mode, destype     2-User defined (bind and lexical) parameters.
 

12. Print one record per page in the output ?
You can set the maximum records per page property of the Repeating frame to

13. page protect ?
Page protect property for an object indicates whether to try to keep the entire object and its contents on the same logical page.
 

14. ‘Print Condition Type’ property ?
1. All,      2. All but First      3. All but First    4.Default     5. First   6. Last.
 

15. Lock option ?
when we set lock option we cannot move the fields in the layout editor outside the frame. This is very useful for maintaining the fields.
 

16. : Can u have more than one layout in report ?
It is possible to have more than one layout in a report by using the additional layout option in the layout editor.
 

17. SRW Package ?
SRW.DO_SQL, SRW.RUN_REPORT, SRW.MESSAGE, SRW.PROGRAM_ABORT, SRW.DO_SQL_FAILURE , SRW.RUN_REPORt  ,  SRW.MESSAGE
 

18. To get report in Excel format ?
Use Spool Command, Text_IO package, UTL package.