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

Share with others

Can't Read? Click to Generate New Code

Enter the verification code shown above into the text box below