Oracle Reports 10g: Build Reports
Course: ORRPTS
Duration: 5 Days
Level: II
On our website at:
http://www.verhoef-training.com/courses/ORRPTS.html
Course Summary
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.
Topics Covered In This Course
INTRODUCTION TO ORACLE10g ODS & REPORTS
- ABOUT ORACLE10g ODS
- 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
REPORTS BUILDER INTERFACE – THE REPORT EDITOR
REPORTS BUILDER INTERFACE – THE OBJECT NAVIGATOR &
PROPERTY INSPECTOR
- MORE ABOUT THE REPORTS BUILDER INTERFACE
- USING THE OBJECT NAVIGATOR
- WORKING WITH THE OBJECT NAVIGATOR
- THE VIEW MENU
- THE TOOLS MENU
- ABOUT THE PROPERTY INSPECTOR
FIELD FORMATTING
- ABOUT FIELD FORMATTING
- CHARACTER FORMATTING
- PAPER LAYOUT FORMATTING
- CONDITIONAL FORMATTING
THE GRAPH WIZARD
- ABOUT 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
- ABOUT THE 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
- ABOUT THIS REPORT
- BUILDING THE REPORT
- CUSTOMIZING THE LAYOUT & FILTERING DATA
ADVANCED DATA MODELS – MATRIX REPORTS
- ABOUT MATRIX REPORTS
- DEFINING A MATRIX REPORT
- CUSTOMIZING A MATRIX REPORT
- NESTED MATRIX REPORTS
UTILIZING REPORT PARAMETERS
- WHAT ARE PARAMETERS?
- SETTING PARAMETER VALUES
EMPLOYING PL/SQL
- MORE ABOUT PL/SQL & ORACLE REPORTS
- REPORT LEVEL TRIGGERS
- PROGRAM UNITS
- PL/SQL LIBRARIES
USING TEMPLATE FILES
- ABOUT TEMPLATES
- LAYOUT OBJECTS WITHIN TEMPLATES
What You Can Expect
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.
Who Should Take This Course
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.
Recommended Prerequisites
Oracle Database 10g: Introduction to SQL
Oracle Database 10g: Programming With PL/SQL
Training Style
Instructor led lectures, combined with many workshops.
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.