Oracle Reports Developer 10g: Build Reports Ed 1 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

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

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
  • Understanding User Requirements
  • Designing Reports
  • Tabular
  • Master-Detail
  • Master with Two Details
  • Matrix
  • Retrieving and Sharing Data
  • Running a Report
  • Reports Developer Executables
  • Invoking Reports Builder
  • Reports Builder Modules
  • Report Data and Layout
  • Reports Builder Components
  • Object Navigator
  • Report-Level Objects
  • Data Model Objects
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
Live Online Training (Duration : 40 Hours) Fee On Request
Group Training Incl. Official Courseware
30 May - 03 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 10 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 08 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours

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.

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
  • Testing Via Qubits
Yes, Koenig Solutions is a Oracle Learning Partner