Oracle Training : Oracle9i ODS Reports

Oracle9i ODS Reports

Oracle Training Overview

Sophisticated graphical reports are possible with Oracle9i 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.

Oracle Training Prerequisites

The course Introduction To Oracle: SQL & Advanced SQL
The course Introduction To Oracle: PL/SQL PL/SQL Programming

Oracle Training 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.

Oracle Training 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.

Suggested Next Courses

The course Introduction To Java Language Programming

Oracle Training Course duration

5 Days

Oracle Training Course outline

Introduction To Oracle Ods & Reports

About Oracle9i Ids
More About Oracle Reports

Introducing The Reports Builder Wizards

An Introduction To The Wizards
Welcome Dialog Wizard
Report Wizard
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

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

About The Graph Wizard
Completing The Graph Wizard For Web Output
Completing The Graph Wizard For Paper Output
Modifying The Graph
Graph Wizard-4

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