Description
This course teaches Oracle Reports 2.5 from the Oracle Developer 2000 toolset. This course is designed to provide the critical programming skills required of all developers working with Oracle.

Audience
Application designers, developers and programmers who will be using Oracle Reports 2.5.

Prerequisites
A familiarity with Oracle’s implementation of SQL and PL/SQL to the level provided by Arkoa’s Using Oracle7 SQL*Plus and Using Oracle7 PL/SQL courses is required.

Hardware and Software
Oracle7 with Reports 2.5 properly installed on any platform, with sufficient logins for the number of participants and instructor.

Format

• Presentation
  
• Hands-on
  

Objectives
After completing this course, participants should be able to:

• Use Oracle Reports 2.5 to create simple reports as well as customized reports
• Add multiple queries to a single report
• Create nested and matrix reports
• Add graphics and text to reports
• Integrate triggers with reports

Introduction to Oracle Reports

• Running Oracle Reports
• Data model objects
• Types of reports

Creating a Simple Report

• Opening a new report
• Adding a query
• The report layout
• The layout editor
• Saving the report
• Running a report

Master-Detail Reports

• Adding a second query
• Linking the queries
• Properties of links
• Formatting the report
• Report frames
• Adding a page header
• Page breaking
• Adding a total
• Combining fields and text

Adding Graphics and Text

• The layout editor
• Page numbers
• Importing graphics
• Linking text files
• Setting report properties

Matrix Reports

• Creating a matrix report
• Creating and linking cross-product groups
• Matrix report frames
• Adding a summary
• Running the report

Further Features of Oracle Reports

• Using triggers
• Report triggers
• Object level triggers
• Creating a format trigger
• System parameter queries
• Creating a user parameter and validation trigger
• Creating a report trigger to supply a default query value
• Extending Reports with lexical parameters
• Customizing the runtime parameter form
• Extending Reports to support detail drill-down