Oracle Reports Developer 10g: Build Reports Ed 1

Overview Schedule & Fees Course Benefits Student Feedback FAQ Course Modules

Oracle Reports Developer 10g: Build Reports Ed 1 Certification Training Course Overview

In this course, learner figure out how to design and construct an assortment of standard and custom Web and paper reports utilizing Oracle Reports Developer (9.0.4.0.1). Working in the definitive condition of Reports Builder, Students figure out how to recover, show, and configuration information from any information source in various revealing styles and distribute the yield to any goal. In this course, understudies figure out how to outline and fabricate an assortment of standard and custom Web and paper reports utilizing Oracle Reports Developer (9.0.4.0.1). Working in the decisive condition of Reports Builder, understudies figure out how to recover, show, and organization information from any information source in various detailing styles and distribute the yield to any goal.

A Live Virtual Class (LVC) is only for enrolled students; unregistered people may not see a LVC whenever. Enrolled students must view the class from the nation recorded in the enlistment shape. Unapproved recording, replicating, or transmission of LVC substance may not be made.

Audience

Business Intelligence Developer
Reports Developer
Technical Consultant

Course Objectives

Add dynamic data to an existing HTML page
Use report parameters and customize a runtime parameter form
Enhance reports using graphs and PL/SQL trigger code
Maximize report performance using OracleAS Reports Services and tune reports
Publish a report on the Web and build reports to run in various languages
Manage report templates, create mailing labels and letters
Identify the main components in a report document and how they are related
Identify the differences between Web and paper reports
Identify standard report design styles and run existing reports to various output destinations
Create and modify basic tabular reports and high quality Web reports
Create other report styles such as break reports and matrix reports
Create reports by accessing data from various data sources

Oracle Reports Developer 10g: Build Reports Ed 1 (40 Hours) Download Course Contents

Live Virtual Classroom

Group Training 3150 15 - 19 Nov GTR 09:00 AM - 05:00 PM CST (8 Hours/Day) 06 - 10 Dec 09:00 AM - 05:00 PM CST (8 Hours/Day)	1-on-1 Training (GTR) 3600 4 Hours 8 Hours Week Days Weekend Start Time : At any time 12 AM 12 PM Training Schedule: GTR=Guaranteed to Run

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Customers who bought this course also bought

Developing Applications for the Java EE 7 Platform Ed 1

MySQL for Database Administrators Ed5 Training Course

Oracle Database 19C:Administration Workshop Certification Training Course

R12.x Oracle General Ledger Management Fundamentals

10% discount on 2nd course:

Course Modules

Module 1:Introduction to Oracle Reports Developer

Business Intelligence
Enterprise Reporting
Oracle Reports Developer
Oracle Database 10g
Oracle Developer Suite 10g
Oracle Application Server 10g
OracleAS Reports Services
OracleAS Reports Services Architecture for the Web

Module 2:Designing and Running Reports

Understanding User Requirements
Designing Reports
Tabular
Master-Detail
Master with Two Details
Matrix
Retrieving and Sharing Data
Running a Report

Module 3:Working in Oracle Reports Developer

Reports Developer Executables
Invoking Reports Builder
Reports Builder Modules
Report Data and Layout
Reports Builder Components
Object Navigator
Report-Level Objects
Data Model Objects

Module 4:Creating a Paper Report

Report Module Components
Building a Paper Report
Viewing the Paper Report Output
Saving the Report Definition
Reentering the Wizard
Creating Break Reports
Break Report Labels
Creating Mailing Labels and Letters

Module 5: Enhancing a Basic Paper Report

What Is the Paper Design?
The Paper Design Window
Modifying a Report
Aligning Columns
Setting a Format Mask
Manipulating Objects
Modifying Visual Attributes
Applying Conditional Formatting

Module 6:Managing Report Templates

Using Report Templates
Modifying a Template
Customizing the Template Margin
Customizing the Template Body
Adding Web Links to a Template for Report HTML Output
Predefining Your Own Templates
Adding a Template Preview Image

Module 7:Creating a Web Report

What Is JSP Technology?
JSP Advantages
Simple JSP Example
Building a Web Report
Using the Report Wizard
Report Editor: Web Source View
JSP Tags
Web Source Example

Module 8:Enhancing Reports Using the Data Model: Queries and Groups

The Data Model Objects
Modifying Properties of a Query
Applying Changes
Changing the Group Structure
Group Hierarchy
Ordering Data in a Group
Query Modifications
Filtering Data in a Group

Module 9:Enhancing Reports Using the Data Model: Data Sources

Data Source Types
Pluggable Data Sources
Using XML as a Data Source
Document Type Definition File
OLAP Data Source
Using Text as a Data Source
Using JDBC as a Data Source
Using REF Cursor Queries

Module 10:Enhancing Reports Using the Data Model: Creating Columns

Data Model Columns
Maintaining Data Source Columns
Producing File Content Output
Creating a Column
Creating Summary Columns
Displaying Subtotals
Displaying Percentages
Creating a Formula Column

Module 11:Enhancing Reports Using the Paper Layout

Viewing the Paper Layout
Designing Multipanel Reports
Printing Multipanel Reports
Different Objects in the Paper Layout
The Paper Layout Layers
Report Processing
Paper Layout Tools
Report Bursting

Module 12:Controlling the Paper Layout: Common Properties

Modifying Paper Layout Object Properties
Common Layout Properties
Sizing Objects
Anchors
Layout Object Relationships
Pagination Icons in the Paper Layout
Controlling Print Frequency
Using Format Triggers

Module 13:Controlling the Paper Layout: Specific Properties

Properties of a Repeating Frame
Specifying Print Direction
Controlling the Number of Records per Page
Controlling Spacing Between Records
Minimum Widow Records
System Variables
Valid Source Columns
Displaying File Contents

Module 14:Web Reporting

Comparing Static and Dynamic Reporting
Adding Dynamic Content
Creating a Report Block
Invoking the Report Block Wizard
Examining the Web Source Code
rw:foreach Tag
rw:field Tag
Customizing Reports JSPs

Module 15: Extending Functionality Using XML

Why Use XML Report Definitions?
Creating XML Report Definitions
Partial Report Definitions: Format Modification Example
Partial Report Definitions: Format Exception Example
Full Report Definition: Data Model Modification Example
Running XML Report Definitions
Debugging XML Report Definitions

Module 16:Creating and Using Report Parameters

Creating User Parameters
Referencing Parameters in a Report Query
Using Bind References
Using Lexical References
Hints and Tips When Referencing Parameters
Creating a List of Values
Referencing System Parameters
Building a Paper Parameter Form

Module 17:Embedding a Graph in a Report

Adding a Graph to a Paper Report
Adding a Graph to a Web Report
Selecting the Graph Type
Selecting the Graph Data
Adding Options to the Graph
Customizing Web Graphs
The rw:graph Tag
Customizing Graphs Using the Graph.XML File

Module 18:Enhancing Matrix Reports

The Matrix Data Model
The Matrix Paper Layout
Creating Matrix Summaries
Creating the Matrix Manually
The Matrix with Group Data Model
The Matrix with Group Layout
Building a Nested Matrix
Nested Matrix Paper Layout

Module 19:Coding PL/SQL Triggers

Types of Triggers in Reports
Trigger Code
Using Report Triggers
Using Data Model Triggers: PL/SQL Group Filter
Using Data Model Triggers: Parameter Validation
Using Layout Triggers
Using Format Triggers
Event-Based Reporting

Module 20:Extending Functionality Using the SRW Package

Contents of the SRW Package
Outputting Messages
Executing a Nested Report
Restricting Data
Initializing Fields
Creating a Table of Contents
Performing DDL Statements
Setting Format Attributes

Module 21:Maximizing Performance Using OracleAS Reports Services

Running Reports Using OracleAS Reports Services
Report Request Methods
Oracle Application Server Components
Enabling Single Sign-On Access
Running the Web Layout: JSP Run-time Architecture
Running the Paper Layout: Servlet Run-time Architecture
Running a Paper Report on the Web
Queue Manager

Module 22:Building Reports: Efficiency Guidelines

Tuning Reports
Performance Measurement
Non SQL Data Sources
Investigating the Data Model
Investigating the Paper Layout
Running the Report
Different Development and Run-Time Environments
Developing Reports to Run in Different GUIs

Download Course Contents

Request More Information

Request a call back?

Course Prerequisites

XML: Introduction or equivalent familiarity with basic XML

Upon Completion of this Course, you will accomplish following:-

Introduction to Oracle Reports Developer
Designing and Running Reports
Working in Oracle Reports Developer
Creating a Paper Report
Enhancing a Basic Paper Report
Managing Report Templates
Creating a Web Report
Enhancing Reports Using the Data Model: Queries and Groups
Enhancing Reports Using the Data Model: Data Sources
Enhancing Reports Using the Data Model: Creating Columns
Enhancing Reports Using the Paper Layout
Controlling the Paper Layout: Common Properties
Controlling the Paper Layout: Specific Properties
Web Reporting

Give an edge to your career with Oracle certifications and training courses. Students can join the classes for Oracle Reports Developer 10g: Build Reports at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.