Oracle Reports course training course

Objectives

To enable the creation, manipulation, extraction of data from an Oracle database it is essential to have a good understanding of the SQL Language. The course takes you through creating and tabular, master detail, matrix and label reports incorporating formatting techniques and the incorporation of images, logos and objects. The course is organised into chapters covering the course objectives in a lecture format interspersed by sets exercises designed to illustrate the points covered and are completed by the delegate.

Oracle Reports Release 6i Training Course Summary

Course Content

What You Will Learn

1.Create and maintain Oracle Reports.
2.Use and enhance the Default report formats.
3.Produce complex tabular, master detail and matrix reports.
4.Produce parameterised front ends for the execution of the report.

Oracle Reports Release 6i Training Course Outline

Introduction to Reports.
· What is Reports and what is it used for?

Invoking the Reports Designer.

Overview of the Designer interface.
Using the Report Design Wizards
Creating a Basic Report.

The Object Navigator The Data Model. 
The Layout Model. 
The Parameter Form 
Modifying Properties 
Saving the report 
Execution & Runtime Output. 

Defining the Data Model 
Queries 
Groups, Columns, Links & Parameters 

The Layout Model

Default Layouts:

Tabular, Master/Detail, Form Letter, Form, Mailing Label, Matrix 

Layout Model Objects:

Frames, Fields, Boilerplates, Anchors. 

Specifying a Runtime Parameter Form.

Creating Reports 
Break Reports 
Forms 
Letters 

Formulas & Summaries 
Creating Formula Columns. 
Creating Group Summaries 
Sub-totals & Grand Totals on your Reports 

Changing Fonts & Modifying Field Properties 
Format Masks 
Fonts & Colours 
Changing Column Labels 

Page Layout Adjusting Page size
Specifying Margins. 
Page Headers & Footers. 
Adding Report Titles. 
Adding Report Dates & Page Numbering. 

Report Headers & Footers
Creating Multiple Page Headers & Footers.

Anchors 
Explicit & Implicit Anchors 
Suppressing Blank Lines
Suppressing & Unsuppressing Text field Display

Creating Forms

Creating Form Letters

Creating Mailing Labels

Creating Matrix Reports

Combination Reports 
Combining default Layouts in a Single Report. 

Creating Parameter Forms

- Parameterising your reports

- Designing Multi-Function Reports.

Adding Buttons, Images and Other Objects to Your Reports.

Creating Templates

Adding Templates to the default design Interface.

The Runtime Interface.