Developer 6i/6.0 Reports

Course Number:  592-JK
Recommended Duration:  3 days

Intended Audience
Developers and other technical personnel who will be creating reports using Developer 6i/6.0 Reports.

Course Overview
This course provides a thorough introduction to the Oracle Reports product.  Students will learn how to create simple and complex reports, use PL/SQL triggers, mailing labels, and cross-matrix reports.  There are nine machine exercises.

 (Oracle Reports Version 3.0 available)

Objectives
Through a series of class exercises, participants will learn to build reports with Developer 6i Reports.  Experiences include data field formatting, master-detail reports, using automatic summaries, cross-matrix reports, and using SQL queries that already exist.

Prerequisites
Participants should be familiar with Oracle and SQL concepts; however, previous Developer Reports or Oracle Reports experience is not assumed.

Topics

• Report Painter and Wizards

• Report Definition

• Query Builder

• Templates

• Format masks, spacing, positioning,

• and headings

• Summaries

• Oracle8i/Oracle8 objects

• Large objects (CLOB and BLOB)

• Master-Detail reporting

• "Boiler-plate" text in report (form letters)

• Report groups

• Extra-wide and multiple page reports

• Cross-matrix reporting

• Report customization

• Call Interface

• Previewer

• PL/SQL and Triggers

• Java beans

• Using Graphics and Pictures

• Web-targeted report