Oracle 10g Reports

Course code: O130

4 days

This is a practical course covering Oracle's flagship report writing tool, Oracle 10g Reports.

Course content >

Who Should Attend?




Course Contents

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.

Training Course Contents

Report Basics

  • What is Oracle Reports
  • Welcome to 10g Report Builder

The Object Navigator

  • Object Navigator Menus
  • Object Navigator Toolbars
  • Object Navigator Structures

Building Basic Reports

  • Creating Reports using Wizards
  • Customising Reports in re-entrants mode
  • Understanding Wizards and side effects

Query Builder

  • Query Builder Tools
  • Building a Query using Query Builder

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

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

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


  • 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

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

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

Generating Reports for the Web

  • Creating web layout
  • Custom JSP report tags
  • Opening an HTML document
  • Embedding Reports into an HTML document

Chart Wizard

  • Creating Bar Charts
  • Different Graph Styles
  • Adding Charts to Reports
Contact us for more information