|
More Resources by
Google: |
|
|
|
|
IMPORTANT-READ
CAREFULLY
In
this tutorial, you will see a substantial amount of Hands-On training on how to
use the Report Builder tool.
Before
going through your Hands-On training, lets take note of the following
important definitions to remember:
-
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.
-
In Hands-On 07, you will
experience how to create a template
-
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.
-
In Hands-On 08, you will
experience how to change your layout report.
-
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.
-
In Hands-On 09, you will
experience how to use and pass a parameter into 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.
-
In Hands-On 10, you will
experience how to generate a drill-down report.
-
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.
-
In Hands-On 11, you will
experience how to use list of values in your report.
-
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 pallete.
Now,
you should first read your case study, and try to solve the questions. Then play the Hands-On training movie until you become
familiar with the subject. For more
information about the subject, you are encouraged to read from a wide selection
of available books.
Good
luck! |