Back to Search Results

Training Course Summary:

This is a practical course covering Oracle's flagship report writing tool, Oracle 10g Reports. The course aims to cover ground level techniques necessary to understand the product, and to implement enterprise standard reports within the development business environment.

Pre-Requisites:

PC Fundamentals
Oracle 10g SQL (O011)
Oracle 10g PL/SQL (O021)

Who Should Attend:

Oracle Analyst/Programmers
Oracle Developers
Oracle DBA's
Oracle Technicians

Training Course Overview/Content:

Report Basics
What is Oracle Reports
Welcome to 10g Report Builder
back to top
The Object Navigator
Object Navigator Menus
Object Navigator Toolbars
Object Navigator Structures
back to top
Building Basic Reports
Creating Reports using Wizards
Customising Reports in re-entrants mode
Understanding Wizards and side effects
back to top
Query Builder
Query Builder Tools
Building a Query using Query Builder
back to top
Data Model
Data Model Work Area
Formula Columns
Control Break Groups using Report Wizard
Control Break Groups Manually
Summary Columns using Report Wizard
Summary Columns Manually
Query Properties
Group Properties
Database Column Properties
Multiple Queries & the Additional Default Layout Tool
Query Data Links
Queries: SQL, JDBC, Text, XML
Ref Cursors
back to top
Live Previewer & Layout Model
Live Previewer Work Area
Report Formatting using Live Previewer
Layout Model Work Area
Layout Model Tools
Layout Model Menus
Report Formatting using Layout Model
Layout Object Properties
Header and Trailer Pages
Margin Page
Direct Column and Field Referencing
back to top
Report Styles
Tabular Report Style
Group Left Report Style
Form Like Report Style
Mailing Label Report Style
Form Letter Report Style
Group Above Report Style
Matrix Report Style
Matrix with Group Report Style
back to top
Templates
Template Editor Work Area
Template Data Model
PL/SQL in Templates
Group Levels in Templates
Adding Templates to Predetermined List
Report Parameters
Setting System Parameters
Creating User Parameters
Building Parameter Drop Down Lists
Parameter Form Builder
Parameter Form Formatting
back to top
PL/SQL in Reports
PL/SQL Overview
PL/SQL Editor
Syntax Palette
Find and Replace in PL/SQL
Report Triggers
Format Triggers
Validation Triggers
Creating Independent Program Units
Building and Using PL/SQL Libraries
SRW.Message Built-ins
SRW.Set_Field Built-ins
Conditional Formatting and SRW.Set Built-ins
back to top
Report Output and Distribution
Generating RTF Output for Word Processors
Generating Delimited Text File Output
Generating HTML Output
Generating HTML Style Sheet Output
Generating XML Output
Generating PDF Output
Setting Report Distribution Properties
Building a Report Distribution File
Distributing Report Output
Bursting to multiple destinations
back to top
Generating Reports for the Web
Creating web layout
Custom JSP report tags
Opening an HTML document
Embedding Reports into an HTML document
back to top
Chart Wizard
Creating Bar Charts
Different Graph Styles
Adding Charts to Reports