Oracle Reports Course UK
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
Course content has been developed for real-world, commercial
scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Duration
3 Days
Who Should Attend
The course is suitable for any personnel involved in the maintenance
and development of Oracle applications and for users with some technical knowledge
who wish to extend that knowledge and for end users who wish to construct their
own reports.
Pre-Requisite Skills
Some degree of computer literacy is required and a basic knowledge
of SQL and PL/SQL.
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.
Associated Course(s)
Oracle Intro to
SQL
Oracle
Intro to PL/SQL
Oracle
6i Forms
Oracle
6i Reports
Oracle Forms
& Reports Hybrid
Oracle
DBA
Oracle
9i New Features
Oracle
Performance Tuning
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.
To book call 0800 028 6400
Oracle Reports Course UK