Oracle9i DS Reports Course

Sophisticated graphical reports are possible with Oracle9iDS Reports. This product is one of the most complex yet powerful graphical reporting tools available. With sufficient training, even some of the most complex reporting requirements can be satisfied using this tool. This course is presented in an intensive workshop format where participants absorb the complex topics of object hierarchies, frame hierarchies, field-level control of report output and many other subjects.

This course is designed for Oracle client/server and web developers.

Upon completion of this course, the participant will be able to:
> Build basic report modules
> Produce all report styles including master-detail, form letter, labels
> Customize report output with frames, PL/SQL triggers and report objects
> Output report contents as HTML pages

Using The Report Wizard    
Developing A Simple Report   
Report Wizard Actions Reviewed   
Report Designer Components   

The Designer Interface    
The Object Navigator    
Object Navigator Elements   
Changing The View    
Understanding Object Navigator Symbols  
Navigation Features And Methods   
Tool Bar Functions, Menus   

Data Model Painter - Part I   
Data Model Painter Components   
The Query Tool And Property Palette  
What Are Groups? How Are Groups Created? 
The Group Property Palette   
Column Ordering     
Using Groups For Breaks    
Break Order Rules & Properties   
Showing The Master/Detail Report   
What Are Computational Columns?   
Summary, Formula, Placeholder Columns  
The Query Link Tool    
Bind, Lexical &System Defined Parameters  
Matrix Reports Overview
Matrix Report Development
Simple Matrix Report Development - Step 1
Creating The Query
Creating The Break Groups
Creating The Cross Product
Creating The Layout Model
Adding Matrix Report Totals
Nested Matrix Reports
A Multi-Query Matrix Report

Layout Model Painter
What Is The Report Editor?
Elements Within The Report Editor
Concepts Within The Report Editor
Using The Tool Palettes
Menus: View, Insert Menu
Format Menu
Custom Spacing Window
Custom Line Sizes Window
Graphics Options; Layout Options
Color Palette; Arrange Menu
Introduction To Report Sections
What Are Logical Pages?
Introduction To Report Layout Frames
General And Advanced Layout Properties
Frames: Regular, Repeating Frames
Framing Models; What Is Three-Space?
Confine And Flex Tools
Filling Matrix Gaps With Zeros

Web Techniques
Layout Fields And Special Techniques

Template Editing

Introduction To Oracle9i SQL
Introduction To Oracle9i Advanced SQL
Introduction To Oracle9i  PL/SQL Language
Develop Oracle9i PL/SQL Program Units