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.
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)
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.
|
|
|