1. What are the various report triggers ? What is their order of firing ?
There are eight report triggers. Of these there are five global triggers called the Report Triggers.
They are fired in the following order :
* Before Parameter Form
* After Parameter Form
* Before Report
* Between Pages
* After Report
Apart from the above Five Report Triggers, there are three other types of triggers :
* Validation Triggers
* Format Triggers
* Action Triggers
Before Form : Fires before the Runtime Parameter Form is displayed. From this trigger, you can access and change the values of parameters, PL/SQL global variables, and report-level columns. (Note : If the Runtime Parameter Form is suppressed, this trigger still fires. Consequently, you can use this trigger for validation of command line parameters).
After Form : Fires after the Runtime Parameter Form is displayed. From this trigger, you can access parameters and check their values. This trigger can also be used to change parameter values or, if an error occurs, return to the Runtime Parameter Form. Columns from the data model are not accessible from this trigger. (Note : If the Runtime Parameter Form is suppressed, the After Form trigger still fires. Consequently, you can use this trigger for validation of command line parameters or other data).
Before Report : Fires before the report is executed but after queries are parsed and data is fetched.
Between Pages : Fires before each page of the report is formatted, except the very first page. This trigger can be used for customized page formatting. (Note : In the Previewer, this trigger only fires the first time that you go to a page. If you subsequently return to the page, the trigger does not fire again.)
After Report : Fires after you exit the Previewer, or after report output is sent to a specified destination, such as a file, a printer, or an Oracle*Mail userid. This trigger can be used to clean up any initial processing that was done, such as deleting tables. Note, however, that this trigger always fires, whether or not your report completed successfully.
Validation Triggers : Validation Triggers are PL/SQL functions that are executed when parameter values are specified on the command line and when you accept the Runtime Parameter Form. (Notice that this means each Validation Trigger may fire twice when you execute the report). Validation Triggers are also used to validate the Initial Value of the parameter in the Parameter property sheet.
Format Triggers : Format Triggers are PL/SQL functions executed before the object is formatted. The trigger can be used to dynamically change the formatting attributes of the object.
Action Triggers : Action Triggers are PL/SQL procedures executed when a button is selected in the Previewer. The trigger can be used to dynamically call another report (drill down) or execute any other PL/SQL.
2. What is the Format Trigger?
Format Trigger is a PL/SQL function. This trigger is going to fire before an object is printed in report output.
it return boolean-true then go to print -false then don't print.
3. What is the diff. when Flex mode is mode on and when it is off?
When flex mode is on, reports automatically resizes the parent when the child is resized.
4. What is the diff. when confine mode is on and when it is off?
When confine mode is on, an object cannot be moved outside its parent in the layout.
5. What is a lexical parameter?
Lexical Parameter is used to replace the where, order by conditions at run time.
6. What are bind variables?
Bind variables are used in report 6i for replacing the single parameter in the select statement
7. How many different layouts are available in Reports?
There are eight different layout formats:
Tabular
Form Like
Form Letter
Mailing Label
Group Left
Group Above
Matrix
Matrix with group
8. What is the minimum number of groups required for a matrix report?
The minimum of groups required for a matrix report are 4
9. What is the lock option in reports layout?
By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields.
10. What is the Anchoring in Reports?
Anchor is used to make fixed distance between two objects in Reports Layout.
* An anchor defines the relative position of an object to the object to which it is anchored.
Anchors are used to determine the vertical and horizontal positioning of a child object relative
to its parent. Since the size of some layout objects may change when the report runs (and data is actually fetched),
you need anchors to define where you want objects to appear relative to one another.
11. What is the difference between Frame and Repeating Frame?
Frames are used to surround other objects and protect them from being overwritten or pushed by other objects.
For example a frame might be used to surround all objects owned by a group to surround column headings or to surround summaries.
12. When you default the layout for a report Report Builder creates frames around report objects as needed;
you can also create a frame manually in the Layout Model view.
Repeating frames surround all of the fields that are created for a group’s columns. The repeating frame prints (is fired) once for each record of the group.
When you default the layout for a report Report Builder creates repeating frames around fields as needed; you can also create a repeating frame manually in the Layout Model view
13. What are different types of column in Oracle reports?
There are three types of columns in the Oracle report these are:
Formula columns: For doing mathematical calculations and returning one value
Summary Columns: For doing summary calculations such as summations etc.
Place holder Columns: These columns are useful for storing the value in a variable
14. What is the difference between Master - Detail Report and report created by breaks ?
Master/detail data models are very similar to break report data models. However, a master/detail data model
is created using two queries, each of which owns at least one group, and a data link. A break report data model
is created using one query and at least two groups. While reports based on a single query are usually more efficient
than reports based on multiple queries, sometimes the structure of your data tables may require you to link multiple tables.
15. What are the various types of anchors in Reports ?
A There are two types of anchors in Oracle Reports:
* implicit (anchors that Oracle Reports creates when a report is run)
* explicit (anchors you create)
Implicit Anchors : At runtime, Oracle Reports generates an implicit anchor for each layout object that does not already have an explicit anchor. It determines for each layout object which objects, if any, can overwrite it, then creates an anchor from the layout object to the closest object that can overwrite it. This prevents the object from being overwritten. The implicit anchor functionality saves you from having to define the positioning of each object. Implicit anchors are not visible in the Layout editor. However, you can specify that the Object Navigator display anchoring information using the Object Navigator Options dialog.
Explicit Anchors : Create an anchor in the Layout editor by clicking on the Anchor tool, dragging from one edge of the child to the one of the parent's edges, then specifying the anchor's properties in its property sheet. Any anchor you create for an object will override its implicit anchoring. Explicit anchors are always visible in the Layout editor unless you specify otherwise via the Layout Options dialog
16. What are Placeholder Columns ?
A placeholder is a "dummy" 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 (e.g., each time the nth record is fetched, or each time a record is fetched containing a specific value, etc.).
17. What are the various Module Types in Reports ?
A You can build three types of modules with Oracle Reports:
* external queries, which are ANSI-standard SQL SELECT statements that can be referenced by modules
* external PL/SQL libraries, which are collections of PL/SQL source code that can be referenced by modules
* reports, which are collections of report-level objects and references to external queries and PL/SQL libraries (optional) that can be referenced by modules
18. What are Physical and Logical pages in Reports ?
A report page can have any length and any width. Because printer pages may be smaller or larger
than your report's "page," the concept of physical and logical pages is used.
Physical Page : A physical page (or panel) is the size of a page that will be output by your printer.
Logical Page : A logical page is the size of one page of your actual report; one logical page may be made
up of multiple physical pages. The Previewer displays the logical pages of your report output, one at a time.
19. What are the various page layout sections in Oracle Reports ?
A report has three sections : the report header pages, report body/margin pages, and report trailer pages.
20. What are various types of parameters ?
A There are two types of parameters:
default (called system parameters)
user-created (called bind and lexical parameters)
21. Types of Matrix report ?
1. Single query 2. Multi query 3. Nested Query 4. Matrix Break
22. Can you create a group without any break columns ?
No.
23. How do you display a message in reports ?
SRW.Message
24. What are the various values of the 'Print Direction' Property of Repeating frames ?
The various values are :
Across : Across means that each instance of the repeating frame subsequent to the first instance is
printed to the right of the previous instance across the logical page.
Across/Down : Across/Down means that each instance of the repeating frame subsequent to the first
instance is printed to the right of the previous instance until an entire instance cannot fit between
the previous instance and the right margin of the logical page. At that time, Oracle Reports prints
the instance below the left-most instance on the logical page, provided there is enough vertical space
left on the logical page for the instance to print completely.
Down : Down means that each instance of the repeating frame subsequent to the first instance is printed below the previous instance down the logical page.
Down/Across : Down/Across means that each instance of the repeating frame subsequent to the first instance is printed below the previous instance until an entire instance cannot fit inside the bottom margin of the logical page. At that time, Oracle Reports prints the instance to the right of the topmost instance on the logical page, provided there is enough horizontal space left on the logical page for the instance to print completely.
25. What is the 'Print Direction' Property of Repeating frames ?
'Print Direction' Property specifies the direction in which successive instances of the repeating frame appear.
No comments:
Post a Comment