Oracle 9i Reports (O230) Training Course

Training Course Objectives

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.

Who Should Attend

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

Training Course Prerequisites

• PC Fundamentals
• Oracle 9i SQL (O010)
• Oracle 9i PL/SQL (O020)
• View Learning Path

Training Course Duration

4 Days

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

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.