Oracle Reports 10g: Build Reports

This course has been superseded

We suggest the following instead:
Power BI Desktop Essentials - 1 Day course

Course 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.

View other Oracle Courses available
5 Days
Contact us for pricing
 

Prerequisites

The course Oracle Database 10g: Introduction to SQL
The course Oracle Database 10g: Program With PL/SQL

Suggested Next Course
The course Introduction To Java Language Programming
The course Oracle AS Discoverer 10g: Create Queries & Reports

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

OracleOracle 10gOracle Database 10g