Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Reports 10g: Build Reports
Oracle Training Overview

This Oracle 10g courseware training guide book will be 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.

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.

Oracle Training Prerequisites

The following courses are mandatory prerequisites for this course:
  • Oracle Database 10g: Introduction to SQL
  • Oracle Database 10g: Program With PL/SQL
Oracle Training 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.

Oracle Training Suggested Next Courses

  • The course Introduction To Java Language Programming
  • The course Oracle AS Discoverer 10g: Create Queries & Reports
Oracle Training Course Objectives

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. The major objectives of this course are:
  • 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.
Oracle Training Course duration

5 Days

Oracle Training Course outline

  • 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

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved