Back to Search Results

Training Course Summary:

Delegates:

This course is aimed at database administrators, software development and technical support personnel who need to create reports in a variety of styles and to customise reports to meet their business requirements.

Objectives:

By the end of this course, delegates will understand the main concepts of Oracle9i Reports Developer. The course is designed to give delegates practical experience in designing and creating Web and paper reports using the Report Wizard, to add dynamic report data to static HTML pages and publish reports on the Web.


Topics Covered:

Reports Builder Capabilities
The Main Components in a Report Document
Standard Report Design Styles
Run Predefined Reports to Different Output Destinations
Build Tabular and Form Reports
Define Report Queries
Apply Queries, Groups, Calculations and Summaries
Edit and Manipulate Layout Objects
Build Master/Detail Reports
Build Matrix Reports
Build Form Letter and Mailing Label Reports
Build and Use Report Templates
Use PL/SQL Trigger Code for Validating and Formatting
Add Boilerplates to Reports
Define and Build Parameter Screens
Add Graphics to a Report
Embed Graphical Charts in a Report
Tune Reports
Use Oracle9iAS Reports Services
Create Web Reports
Publish a Report on the Web
Build Reports Using XML
Add Dynamic Data to an HTML Page



Requirements:

A working knowledge of SQL*Plus and PL/SQL is required. This can be obtained by attendance on the Pre-Requisite courses. Familiarity with basic XML would be an advantage.

Pre-Requisites Courses:

SQL*Plus

PL/SQL


Follow-On Courses:

Forms 6i - Part I

Forms 9i - Part I

DBA Part I - Architecture & Administration