Developer 10g/9i Reports

Course Number:  589-JK
Recommended Duration:  3 days

Intended Audience
Developers and other technical personnel who will be creating reports using Developer 10g/9i Reports.

Course Overview
Provides a thorough introduction to the Developer 9i Reports product.  Students will learn how to create simple and complex reports, use PL/SQL triggers, mailing labels, cross-matrix reports, and how to deploy to the web and other deployment options.  There are nine machine exercises.

Objectives
Through a series of class exercises, participants will learn to build reports with Developer 10g/9i Reports.  Experiences include data field formatting, master-detail reports, using automatic summaries, cross-matrix reports, deployment options, 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

• Oracle objects

• Large objects (CLOB and BLOB)

• Master-Detail reporting

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

• Extra-wide and multiple page reports

• Cross-matrix reporting

• Report customization

• Previewer

• PL/SQL and Triggers

• Java beans

• Web-targeted reports

• Deployment options (XML, RTF, etc...)