Home > Training > Oracle Reports 6i: Build Internet Reports

Description:

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

Prerequisites:

Develop PL/SQL Program Units
Introduction to Oracle: SQL and PL/SQL

Course Objectives:

Control report access and security
Identify the main components in a report and their relationships
Register a report in WebDB
Use runtime parameters and customize a runtime parameter form
Manage report templates
Create and modify standard report design styles
Publish a report on the Web
Create and embed a chart in a report
Embed calls to Java applets

Course Topics:

Introduction to Oracle Reports
What is Business Intelligence?
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 and 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

 

Next>>