+1 (778) 681-0711

Oracle Reports Developer 10g: Build Reports Ed 1

Duration : 5 Days (40 Hours)

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

In the Oracle Reports Developer course, learners will gain the expertise to design and create various standard and custom Web and paper reports using Oracle Reports Developer (9.0.4.0.1). Operating within the definitive environment of Reports Builder, students will learn to retrieve, display, and format data from any data source in multiple reporting styles and publish the output to any destination. The course equips students with the skills to effectively utilize Oracle Reports Developer for generating dynamic and professional reports, both for web and paper distribution. By the end of the course, participants will be proficient in designing and deploying various reporting styles, ensuring accurate and timely data presentation in a variety of output formats.

Intended Audience:

  • Business Intelligence Developer
  • Reports Developer
  • Technical Consultant

Learning Objectives of Oracle Reports Developer 10g: Build Reports Ed 1:

  • 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
 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

Oracle Reports Developer 10g: Build Reports Ed 1 Course Prerequisites:

  • XML: Introduction or equivalent familiarity with basic XML

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability

Classroom

  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention

Onsite

  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.
×