Loading...

Oracle 9i Reports

Course code: O230

4 days

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

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

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

Training Course Contents

Report Basics

  • What is Oracle Reports
  • Welcome to Report Builder

The Object Navigator

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

Building Basic Reports

  • Using the Report Wizard
  • Using the Data Wizard Manually
  • What Data Model Objects Were Built
  • What Layout Model Objects Were Built
  • What Obect Navigator Objects Were Built

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

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

PL/SQL in Reports

  • PL/SQL Overview
  • Oracle 9i Support
  • 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
  • Property Palette
  • ActiveX Controls
  • PCL Support
Contact us for more information