"Education is the
ability to listen to almost anything without losing your temper
or your self confidence." Robert Frost (1874 - 1963) |
IMPORTANT-READ CAREFULLY
Tabular report shows
data in a table format. It is similar in concept to the idea of an
Oracle table. Oracle, by default, returns output from your select
statement in tabular format.
Group-left reports are
very useful for generating output reports from SQL statements with the
group by clause. The Group-left report suppresses redundant printings
of the same value in the leftmost column of the report. It is like
making a control break in your report. You can use the "Group-left"
report on a master-detail relationship as well.
In Hands-On 02, you will
experience how to generate a group left report.
A Mailing Label report
is a list of addresses designed to be generated on mailing labels. The
addresses can be printed across the page, and then down or vice versa.
In Hands-On 03, you will
experience how to generate a Mailing Label report.
A matrix report is a
chart with two axes (rows and columns) that display for sets of data.
On the rows, the report displays one set of data, while on the columns
the report displays another set. Within the two axes, report displays
a cross-product of results.
In Hands-On 04, you will
experience how to generate a Matrix report.
The Form letter
report will complement the mailing label report. You can pull several
database columns plus your mailing message to produce form mailings.
In Hands-On 05, you will
learn how to generate a Form Letter report.
A Group-Above report
is a style you use to demonstrate a master/detail relationship in your
database. You should define a master group, and for each master
record, the report obtains the related values from the detail groups.
The "Data Model"
will be used to display the data content and layout appearance of the
report.
The "Live Pre-viewer"
will be used to view what the report will look like when it is
executed.
Object Navigator will
be used to view report components and navigate through the report
objects. It gives you a hierarchical listing of all the modules open
in your current session. You use this listing to navigate to, and work
on, those objects. It gives you access to all database objects you own
or have grant to, as well as a list of all the built-in functions and
procedures you can use in Oracle Form Builder. Clicking on the plus
sign next to an object in the Object Navigator will expand the object
and clicking on the minus sign will collapse the object.
Property Palette
contains object properties. The contents of the Property Palette are
referred to as the "Property sheet" for the object. You use the
Property Palette to modify object properties. To open the Property
Palette of an object, go to the object and right click on the mouse
then select Property Palette.
Templates are generic
objects that allows you to force a set of standard features and
attributes onto your reports. They help you impose uniformity on your.
Layout Model shows you
how your report will appear. When you run your report, Report Builder
fills in the objects in the Layout Model with actual data. The Layout
Model will show you several types of layout objects and the
relationships that exist between them. The Layout Model uses symbols
and graphical representations to show these relationships.
There are two types of
parameters: user parameters and system parameters.
"User parameters"
will be used to manage the behavior and output of your reports.
"System parameters"
will be used to manage the report runtime behavior of your reports
such as defining your output destination.
"Parameter Form
Builder" tool will be used to design your runtime parameter
form.
The Runtime Parameter
Form appears whenever you run your report.
A drill-down report
lets you get more detailed information at a different level of data
aggregation. The most common methods of drilling-down use the mouse or
a button to call another report, graph, or form.
A "List of Values",
can be used as a validation mechanism for values defined in user
parameters. Your LOV or "List of Values" can consist either of
static values or items queried from the database using select
statements.
The Object Navigator
will be used to view report components and navigate through the report
objects. It gives you a hierarchical listing of all the modules open
in your current session. You use this listing to navigate to, and work
on, those objects. It gives you access to all database objects you own
or have grant to, as well as a list of all the built-in functions and
procedures you can use in Oracle Form Builder. Clicking on the plus
sign next to an object in the Object Navigator will expand the object
and clicking on the minus sign will collapse the object.
A Property Palette
contains object properties. The contents of the Property Palette are
referred to as the "Property sheet" for the object. You use the
Property Palette to modify object properties. To open the Property
Palette of an object, go to the object and right click on the mouse,
then select property palette.
|