INFORMIT logo
InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
ABOUT
 
 ORACLE 10g
 
  10g DBA Track  
  10g iDS Track  
  10g Java Develop. Track  
  10g App. Server Track  
 
ORACLE 9i
 
  9i DBA Track  
  9i iDS Track  
  9i J2EE Java Develop. Track  
  9i AS Web Adm. Track  
 
Oracle Data Warehouse
 
   
   
     
  ORACLE CERTIFICATION  
  ORACLE UNIVERSITY  
     
   
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
Oracle 10g: Build Reports

In this course, students learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer. Working in the declarative environment of Reports Builder, students learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination. Students also learn how to customize more complex reports, embed graphical charts, and use OracleAS Reports Services to deploy your reports.

 

Course schedule

Duration: 30 hours
To view the schedule for this class, click here.

Who should attend

This course is valuable for those involved in developing applications with Developer, including consultants, engineers, analysts, manager and others.

Prerequisites

•  Oracle10g: Program with PL/SQL
. or equivalent knowledge

Course Outline

INTRODUCTION TO ORACLE REPORTS DEVELOPER
▪ Business Intelligence
▪ OracleAS Reports Services

DESIGNING AND RUNNING REPORTS
▪ Designing Reports
▪ Tabular, Master-Detail, Master with Two Details
▪ Matrix
▪ Retrieving and Sharing Data

WORKING IN ORACLE REPORTS DEVELOPER
▪ Reports Developer Executables
▪ Reports Builder Components

CREATING A PAPER REPORT
▪ Building & Viewing the Paper Report Output
▪ Creating Break Reports
▪ Creating Mailing Labels and Letters

ENHANCING A BASIC PAPER REPORT
▪ Aligning Columns
▪ Setting a Format Mask
▪ Applying Conditional Formatting

MANAGING REPORT TEMPLATES
▪ Customizing the Template Margin & the Template Body
▪ Adding Web Links to a Template

CREATING A WEB REPORT
▪ JSP Advantages
▪ Building a Web Report

THE DATA MODEL: QUERIES AND GROUPS
▪ Modifying Properties of a Query
▪ Changing the Group Structure
▪ Ordering & Filtering Data in a Group

THE DATA MODEL: DATA SOURCES
▪ Using XML as a Data Source
▪ OLAP Data Source
▪ Using Text or Using JDBC as a Data Source

THE DATA MODEL: CREATING COLUMNS
▪ Producing File Content Output
▪ Displaying Subtotals, Percentages, & a Formula Columns

ENHANCING REPORTS USING THE PAPER LAYOUT
▪ Designing & Printing Multipanel Reports
▪ Paper Layout Tools
▪ Report Bursting

CONTROLLING THE PAPER LAYOUT: COMMON PROPERTIES
▪ Modifying Paper Layout Object Properties
▪ Pagination Icons in the Paper Layout
▪ Using Format Triggers

CONTROLLING THE PAPER LAYOUT: SPECIFIC PROPERTIES
▪ Properties of a Repeating Frame
▪ Specifying Print Direction
▪ System Variables
▪ Displaying File Contents

WEB REPORTING
▪ Adding Dynamic Content
▪ rw:foreach & field Tag
▪ Customizing Reports JSPs

EXTENDING FUNCTIONALITY USING XML
▪ Partial Report Definitions
▪ Full Report Definition
▪ Running & Debugging XML Report Definitions

CREATING AND USING REPORT PARAMETERS
▪ Using Bind References & Lexical References
▪ Creating a LOV
▪ System & Paper Parameters

EMBEDDING A GRAPH IN A REPORT
▪ Adding a Graph to a Paper Report & a Web Report
▪ Selecting the Graph Type & Graph Data

ENHANCING MATRIX REPORTS
▪ The Matrix Data Model & Paper Layout
▪ The Matrix with Group Data Model & Group Layout
▪ Building a Nested Matrix

CODING PL/SQL TRIGGERS
▪ Using Report Triggers
▪ Group Filter
▪ Using Layout Triggers & Format Triggers
▪ Event-Based Reporting

EXTENDING FUNCTIONALITY USING THE SRW PACKAGE
▪ Restricting Data
▪ Initializing Fields
▪ Creating a Table of Contents
▪ Performing DDL Statements

ORACLEAS REPORTS SERVICES
▪ Reports Services
▪ Report Request Methods
▪ Enabling Single Sign-On Access
▪ Running the Web Layout & Paper Layout
▪ Queue Manager

BUILDING REPORTS: EFFICIENCY GUIDELINES
▪ Performance Measurement
▪ Investigating the Data Model & Paper Layout
▪ Different Development and Run-Time Environments

 

 

 
 


INFORMIT - Skill Development Center
Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
Fax. (022) 4231 168 - E-mail: info@informit.tc

 
  Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
© 2006, InformIT Ganesa Pratama. All Right Reserved