10g Reports

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

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
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