DESCRIPTION
In this course students will learn the features of Oracle10g ODS Reports, one of the most complex yet powerful graphical reporting tools available. Students will get a solid foundation of this tool and explore some of the most commonly used techniques for publication of information. 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.
DURATION: 5 Days
COURSE OBJECTIVES
- Consideration of the structure of Oracle Reports, the Oracle Development Suite (ODS) and the overall Oracle enterprise architecture.
- Distribution of reports in all supported formats including HTML, HTML with embedded Java Server Pages, PDF and hardcopy.
- Quickly building prototypes with the various wizards of the Oracle Reports Builder tool.
- Customizing prototypes using the Report Editor
- Individual field formatting for both web and paper layout.
- Advanced customization of the data model.
- Advanced customization of the layout objects.
- Utilizing specialty techniques such as parameters, reusable PL/SQL programs and template files.
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.
PREREQUISITES
Oracle Foundation Classes (SQL Basics & SQL Plus and PL/SQL Workshop) or familiarity with SQL and PL/SQL or equivalent experience.
FORMAT/MATERIALS
This course includes a combination of lecture, discussion and numerous computer workshops. Students will receive an extensive course manual covering Oracle Reports, which will be a valuable reference after class.
CONTENT:
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