Oracle Reports

Duration:

4 Days

Description:

This course provides the student with instruction using Oracle Reports, the report writer
component of the Oracle Developer suite. The student will build complete productionstyle
reports using Oracle Reports and various layout styles such as master-detail, tabular,
label, and matrix. Inclusion of images and other graphical items will be included as well
as how to use user-defined parameters.

Topics

Overview of Oracle Reports

Oracle Reports objects

Designer interface

The object navigator

Object navigator views

Oracle Reports filetypes and storage methods

Oracle Reports executables

Oracle Reports on-line help system

Using report wizards

Creating a default report

Viewing and modifying reports using the live previewer

Using the Data Model/Layout Editor

Tabular Reports

Data Model objects

Data Model objects created by default

Layout objects

Layout objects created by default

Tool palettes

Oracle Reports menus

Overview of the reports server

Using report templates

Break reports

Defining and modifying properties

Matrix reports

Creating and using parameters

Placing graphics and images in your report

Using headers and footers

Sizing and positioning objects in the layout editor

Arranging objects in the layout

Manually creating objects in the layout editor

Creating margins

Page numbering

Using colors and the color palette

Creating and customizing the parameter form

Outputting messages at runtime

Embedding a chart in a report

Referencing a PL/SQL library

Overview of the report builder built-in package, SRW

Form letter/Mailing label reports

Using external queries

Report and format triggers

Master/Detail reports

Using summaries and formulas

Audience

This course is designed for application developers.

Pre-requisites

The student should have a complete understanding of SQL, SQL*Plus, PL/SQL, and Relational Database Concepts.

Scheduled Classes