Oracle
Reports 10g: Build Reports (5 Days)
Description
Sophisticated graphical reports are possible
with Oracle10g ODS Reports. This product is one of the most complex yet
powerful graphical reporting tools available. With sufficient training, even
some of the most complex reporting requirements can be satisfied using this
tool. This course is presented in an intensive workshop format where
participants absorb the complex topics of object hierarchies, frame
hierarchies, field-level control of report output and many other subjects.
Course Objectives
Oracle Reports is one of the most functionally rich, and
therefore complex, products available from Oracle Corporation. There is
virtually no limit to the combination of options and features that can be used
to produce reports. Within this course we seek to introduce you to this tool
and explore some of the most commonly used techniques for publication of
information. The major objectives of this course are:
·
Consideration of the structure of Oracle
Reports, the Oracle Development Suite (ODS) and the overall Oracle enterprise
architecture.
·
Distribution of reports in all supported
formats including HTML, HTML with embedded Java Server Pages, PDF and hardcopy.
·
Quickly building prototypes with the various
wizards of the Oracle Reports Builder tool.
·
Customizing prototypes using the Report
Editor.
·
Individual field formatting for both web and
paper layout.
·
Advanced customization of the data model.
·
Advanced customization of the layout
objects.
·
Utilizing specialty techniques such as
parameters, reusable PL/SQL programs and template files.
Audience
The target audience for this course is application developers
and designers, as well as their management, who will be developing Internet
applications using the Oracle Reports product.
Mandatory Prerequisites
·
Oracle Database 10g: Introduction to SQL
·
Oracle Database 10g: Program With PL/SQL
Suggested Next Course
·
Introduction To Java Language Programming
Course Outline
INTRODUCTION
TO ORACLE10G ODS & REPORTS
·
ABOUT
THE ORACLE10G ENTERPRISE ARCHITECTURE
·
SMP
·
MORE
ABOUT ORACLE REPORTS
INTRODUCING
THE REPORTS BUILDER WIZARDS
·
AN
INTRODUCTION TO THE WIZARDS
·
WELCOME
DIALOG WIZARD
·
REPORT
WIZARD
REPORT
WIZARD PRODUCTIVITY FEATURES
·
RE-ENTERING
THE WIZARDS
·
USING
THE QUERY BUILDER TOOL
BUILDING
MASTER-DETAIL REPORTS
THE
REPORT EDITOR
THE
OBJECT NAVIGATOR & PROPERTY INSPECTOR
·
USING
THE OBJECT NAVIGATOR
·
WORKING
WITH THE OBJECT NAVIGATOR
·
THE VIEW
MENU
·
THE
TOOLS MENU
·
ABOUT
THE PROPERTY INSPECTOR
FIELD
FORMATTING
·
CHARACTER
FORMATTING
·
PAPER
LAYOUT FORMATTING
·
CONDITIONAL
FORMATTING
THE
GRAPH WIZARD
·
COMPLETING
THE GRAPH WIZARD FOR WEB OUTPUT
·
COMPLETING
THE GRAPH WIZARD FOR PAPER OUTPUT
·
MODIFYING
THE GRAPH
REPORTS
BUILDER INTERFACE - THE FILE MENU
·
USING
THE FILE MENU
·
MODULE
& SESSION CONTROL
·
REPORT
DISTRIBUTION
·
MODULE
ADMINISTRATION
REPORTS
BUILDER INTERFACE - EDITING PREFERENCES
DATA
MODEL VIEW - ENHANCING PROTOTYPE REPORTS
·
USING
THE DATA MODEL VIEW
·
USING
THE DATA WIZARD
·
WORKING
WITH DATA MODEL VIEW OBJECTS
LAYOUT
OBJECTS
·
MORE
ABOUT THE PAPER LAYOUT VIEW
·
WHAT ARE
THE LAYOUT OBJECTS?
·
ADDING
STANDARD OBJECTS
·
ADDING
WEB PROPERTIES TO OBJECTS
·
THE
REPORT BLOCK WIZARD
ADVANCED
DATA MODELS - MULTI-GROUP & MULTI-BLOCK REPORTS
·
BUILDING
THE REPORT
·
CUSTOMIZING
THE LAYOUT & FILTERING DATA
ADVANCED
DATA MODELS -
MATRIX
REPORTS
·
DEFINING
A MATRIX REPORT
·
CUSTOMIZING
A MATRIX REPORT
·
NESTED
MATRIX REPORTS
UTILIZING
REPORT PARAMETERS
·
SETTING
PARAMETER VALUES
EMPLOYING
PL/SQL
·
REPORT
LEVEL TRIGGERS
·
PROGRAM
UNITS
·
PL/SQL
LIBRARIES
·
USING
TEMPLATE FILES
·
ABOUT
TEMPLATES
·
LAYOUT
OBJECTS WITHIN TEMPLATES