Putting America Back to Work, through advance industry specific education, providing the tools necessary to hold the knowledge force in America, is our mission.

Report Basics

• Report Basics and The Object Navigator
• What is Oracle Reports
• Welcome to Report Builder
• Object Navigator Menus
• Object Navigator Toolbars
• Object Navigator Structures

Report Wizard

• Building a Basic Report
• 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

Data Model

• Data Model
• Data Model Work Area
• Formula Columns
• Control Break Groups Using the Report Wizard
• Control Break Groups Manually
• Summary Columns using the Report Wizard
• Summary Columns Manually
• Query Properties
• Group Properties
• Database Column Properties
• Multiple Queries & the Additional Default Layout Tool
• Query Data Links
• Query Builder

Layout and Preview and Styles

• Live Previewer & Layout Model
• Live Previewer Work Area
• Report Formatting using the Live Previewer
• Layout Model Work Area
• Layout Model Tools
• Layout Model Menus
• Report Formatting using the Layout Model
• Layout Object Proporties
• Header and Trailer Pages
• Margin Page
• Direct Column and Field Referencing
• 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

• Templates
• Template Editor Work Area
• Template Data Model
• PL/SQL in Templates
• Group Levels in Templates
• Adding Templates to the Predetermined List

Report Editor

• Welcome Dialog Box
• Create New Report Dialogue Box
• Integration with other Oracle Tools
• Database Role Support
• Report Editor
• Property Palette
• ActiveX Controls
• PCL Support

Object Navigator

• Object Navigator
• Object Navigator Menus and Buttons
• File Menu
• Program Menu
• Tools Menu
• Object Navigator Structures
• Templates Node
• Live Previewer Node
• Report Triggers
• Report Sectioning
• The Solution

Data Model Wizard

• Data Model and Data Wizard
• Data Model Tools
• Data Wizard
• Ref Cursors
• Query Builder
• Query Builder Tools
• Building a Query Using Query Builder

Chart Wizard

• Chart Wizard
• Chart Hyperlinks
• Parameter Form
• Templates
• Creating a Template
• Template Editor
• Inheritance In Templates
• Adding Templates to Predefined List
 
Report Parameters

• Report Parameters
• Setting System Parameters
• Creating User Parameters
• Building Parameter Drop Down Lists
• Parameter Form Builder
• Parameter Form Formatting

Triggers

• 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 In
• SRW.Set_Field Built Ins
• Conditional Formatting and the SRW.Set Built Ins

Reports Output

• 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

Reports and Web

• Preparing Reports for the Web
• What is the Report Server?
• Using the WEB Wizard
• Setting the WEB Properties
• Interactive Reporting
• Creating Buttons in Reports
• Drilling Through Reports Using SRW.Run_Report
• Miscellaneous 9i Features

Report Distribution

• Report Distribution & File Generation
• New Destination Types
• Delimited Reporting
• Report Distribution

PLSQL and Database

• PL/SQL and Database Support
• PL/SQL and Database Support
• PL/SQL and Database Support in Reports 3
• PL/SQL and Database Support in Reports 6/6i/9i
• PL/SQL conversion
• Dynamic Printer Tray Support
• SRW Replacement for SET_ATTR
• Web Built Ins
• Syntax Palette
• Search and Replace in PL/SQL

Web / Reports Server

• WEB Support
• Reports Server
• Reports Queue Manager
• WEB Properties
• HTML Page Streaming
• Web Wizard
• Reports 9i WEB Enhancements
• Reports Server
• Architecture
• Configuration
• Deployment
• Tuning