Oracle Reports 10g: Build Reports Course

Course Code: RT 360
Course Abstract:

Oracle Reports is one of the most functionally rich, and therefore complex, products available from Oracle Corporation. There is virtually no limit to the combination of options and features that can be used to produce reports. Within this course we seek to introduce you to this tool and explore some of the most commonly used techniques for publication of information.

Sophisticated graphical reports are possible with Oracle10g ODS 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.

Audience: The target audience for this course is application developers and designers, as well as their management, who will be developing Internet applications using the Oracle Reports product.
Duration: 5 days
Learning Outcomes: Upon completion of this course, the participant will be able to:
> Consider the structure of Oracle Reports, the Oracle Development Suite (ODS) and the overall Oracle enterprise architecture
> Distribute reports in all supported formats including HTML, HTML with embedded Java Server Pages, PDF and hardcopy
> Quickly build prototypes with the various wizards of the Oracle Reports Builder tool
> Customize prototypes using the Report Editor
> Format individual fields for both web and paper layout
> Customize the data model
> Customize the layout objects
> Utilize specialty techniques such as parameters, reusable PL/SQL programs and template files
Course Topics:

Introduction To Oracle10g ODS & Reports
About Oracle10g ODS
About The Oracle10g Enterprise Architecture
Smp
More About Oracle Reports

Introducing The Reports Builder Wizards
An Introduction To The Wizards
Welcome Dialog Wizard
Report Wizard

Report Wizard Productivity Features
Re-Entering The Wizards
Using The Query Builder Tool
Building Master-Detail Reports
Reports Builder Interface – The Report Editor

Reports Builder Interface – The Object Navigator & Property Inspector
More About The Reports Builder Interface
Using The Object Navigator
Working With The Object Navigator
The View Menu
The Tools Menu
About The Property Inspector

Field Formatting
About Field Formatting
Character Formatting
Paper Layout Formatting
Conditional Formatting

The Graph Wizard
About The Graph Wizard
Completing The Graph Wizard For Web Output
Completing The Graph Wizard For Paper Output
Modifying The Graph

Reports Builder Interface – The File Menu
Using The File Menu
Module & Session Control
Report Distribution
Module Administration
Reports Builder Interface – Editing Preferences

Data Model View – Enhancing Prototype Reports
Using The Data Model View
Using The Data Wizard
Working With Data Model View Objects

Layout Objects
About The Layout Objects
More About The Paper Layout View
What Are The Layout Objects?
Adding Standard Objects
Adding Web Properties To Objects
The Report Block Wizard

Advanced Data Models – Multi-Group & Multi-Block Reports
About This Report
Building The Report
Customizing The Layout & Filtering Data

Advanced Data Models – Matrix Reports
About Matrix Reports
Defining A Matrix Report
Customizing A Matrix Report
Nested Matrix Reports

Utilizing Report Parameters
What Are Parameters?
Setting Parameter Values

Employing PL/SQL
More About PL/SQL & Oracle Reports
Report Level Triggers
Program Units
PL/SQL Libraries

Using Template Files
About Templates
Layout Objects Within Templates

Prerequisites: Oracle Database 10g: Introduction to SQL
Oracle Database 10g: Programming with PL/SQL
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning

Testimonials

“Fantastic instructor. His patience and way of interacting with the class was refreshing and made me feel comfortable in asking questions.”

Student – Advanced UNIX Korn Shell Scripting