Back to Search Results

Training Course Summary:

In this course students build a variety of standard and custom reports using Oracle Reports 6i and run the reports both in client-server and on the Web. Working in a graphical user interface environment, students learn to retrieve, display, and format data in numerous reporting styles. Students will also learn to customize more complex reports, embed graphical charts, and use the Reports Server. The course covers building reports for the Web, calling Java applets, using reports administration and security, and integrating WebDB sites

Pre-Requisites:

Introduction to Oracle SQL and PL/SQL (SPLI)
or
Introduction to Oracle for Experienced SQL Users
Develop PL/SQL Program Units (DPP)

Training Course Overview/Content:

Introduction to Oracle Reports
Enterprise Reporting
What is Report Builder?
Where Does Oracle Developer Fit In?
Report Builder Components
Getting Started in the Oracle Reports Interface
Customizing Your Oracle Reports Session
Introducing the Course Application

Designing and Running Reports
Designing Reports
Understanding the User Requirements
Choosing the Report Style
Retrieving and Sharing Data
Running a Report
Viewing the Report Output

Report Builder Concepts
Reports Executables
Types of Report Builder Modules
Report Builder Components
Object Categories

Creating Reports Using the Report Wizard
Invoking the Report Builder
Creating a Tabular Report Using the Report Wizard
Modifying a Report Using the Report Wizard
Adding Summaries
Creating Mailing Labels
Creating Letters
Web-Enabling a Report Using the Web Wizard
Publishing and Viewing a Report on the Web

Enhancing a Report in the Live Previewer
What is the Live Previewer?
Modifying a Report in the Live Previewer
Aligning Columns
Setting Format Masks
Manipulating Objects
Changing Text
Modifying Visual Attributes
Creating Format Exceptions
Inserting Page Numbers, Current Date, and Time

Managing Report Templates
The Reports Template Editor
Modifying a Predefined Template
Adding Web Links to a Template for HTML Output
Registering a Customized Template

Reports Storage Methods
Storage Methods and Requirements
Sharing Reports Among Developers
Converting Between Storage Types
Documenting Reports
File Types and Portability

Enhancing Reports Using the Data Model: Creating Queries and Groups
The Data Model Objects
Changing the Group Structure
Ordering Data in a Group Using the Break Order Property
Eliminating Data Using Group Filters
Adding New Data
Linking Data from Different Queries Using a Data Link

Enhancing Reports Using the Data Model: Creating Columns
Maintaining Database Columns
Using a Database Column
Creating Summary Columns
Creating Formula Columns
Creating Placeholder Columns

Enhancing Reports Using the Layout Model
The Three-Report Sections
Report Bursting
Creating a Multipanel Report for Large Sets of Data
Displaying a Video Clip Using a Button
Implicit and Explicit Anchors
Positioning One Object Relative to Another Using an Explicit Anchor
Suppressing Gaps in Conditional Reports Using an Explicit Anchor
Web Support for Layout Objects

Modifying Common Layout Properties
Modifying Common Layout Properties
Using Format Triggers
Modifying Web Setting Properties

Modifying Specific Layout Properties
Controlling the Print Direction of a Repeating Frame
Controlling Pagination of a Repeating Frame
Controlling Spacing Between Records
Creating New Fields in the Layout and Modifying the Properties
Creating a Link File to Display File Contents

Using Report Parameters and Customizing a Parameter Form
Creating User Parameters
Referencing User Parameters
Creating Lists of Values for Parameters
Referencing System Parameters
Creating a Parameter Form Layout
Customizing the Parameter Form Layout
Creating Parameter HTML Extensions
Embedding a Chart in a Report
Creating and Embedding a Graphics Chart Using the Chart Wizard

Embedding an Existing Graphics Chart in a Report
Restricting Chart Data with a User Parameter
Passing Report Data to the Chart
Creating Chart Hyperlinks

Enhancing Matrix Reports
The Matrix Data Model
The Matrix Layout Model
Creating Matrix Summaries
Creating a Nested Matrix Report Using the Wizards

Coding PL/SQL Triggers in Reports
Trigger Types
Creating Report Triggers
Creating Data Model Triggers
Creating Layout Model Triggers
Writing Common Code

Building Reports for the Web
Building Reports for the Web
Static Web Reporting
Dynamic Web Reporting
Building Web Drill-Down Reports

Using the Report Builder Built-In Package
Contents of the Report Builder Built-in Package
Outputting Runtime Messages
Managing Temporary Tables
Modifying Visual Attributes Dynamically
Controlling the Printer Output Dynamically
Suppressing Butt