Oracle Developer Reports

AUDIENCE: This course is for programmers and developers who need a comprehensive introduction to Reports. The course takes students though reports development in Oracle Developer Reports, beginning with basic report design and ending up with fully integrated applications rollout. The workshops are designed to mimic a true application building process.
PREREQUISITES: A good knowledge of SQL and PL/SQL, preferably gained through attendance of a suitable course like Verhoef''s Oracle SQL and PL/SQL courses together with some experience of using these products in an everyday role. Knowledge of the GUI environment would be advantageous.
DURATION: 3 days. Hands on.
OBJECTIVES: This course covers the fundamental concepts of Oracle Reports in order to allow the delegate to create reports, making effective use of the enhanced procedural and report layout features. Delegates will gain sufficient knowledge from this course to enable them to become productive immediately on completion.
COURSE CONTENT:
Oracle Reports Overview
Introduction
The environment
Data model editor
A simple report

Oracle Reports Architecture
Invoking the designer and connecting to a database
Viewing the structure
How to access an object
How to create new objects
Editing objects
Removing objects
Report properties
Data model editor
Layout editor
Parameter form editor
Program units node and built-ins
Reports interface components
Tips for creating reports
Hands on practice

Creating Reports
Using the report wizards
Specifying the data
Queries
Groups
Database columns
Data model tools
Hands on practice

Creating Layouts
The layout editor
The default layout
Frames
Repeating frames
Specifying a default layout
Saving and running a report
Viewing report output
Hands on practice

Manipulating Layouts
Options
Creating a break report
Updating the report layout
Headers and trailers
Report body and margins
Fields
Adding text
Adding drawings
Graph Wizard
Changing fonts
Modifying field properties
Adding boilerplate text
Adding a report heading
Adding a run date
Hands on practice

Building Reports
Multi-query reports
Data links
Creating master / detail reports
Frames revisited
Repeating frames revisited
Fields
User created boilerplate text
Anchors
Adding additional layouts
Hands on practice
Creating a new report
Creating a label report
Creating a form letter report
An introduction to matrix reports
Adding parameters to a report
Templates
Calling reports from Forms
Hands on practice

PI07/01