Search for Training

Oracle Reports 10g

Course Overview


Oracle Reports 10g

Course Content


INTRODUCTION

  • Business Intelligence
  • Enterprise Reporting
  • Oracle Reports Developer
  • Oracle Database 10g
  • Oracle Developer Suite 10g
  • OracleAS 10g
  • OracleAS Reports Services

DESIGNING AND RUNNING REPORTS

  • 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

CREATING AND ENHANCING A PAPER REPORT

  • Report Module Components
  • Building a Paper Report and Viewing 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

MANAGING REPORT TEMPLATES

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

CREATING A WEB REPORT

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

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

ENHANCING REPORTS USING THE DATA MODEL

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

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

ENHANCING REPORTS USING THE PAPER LAYOUT

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

CONTROLLING THE PAPER LAYOUT

  • 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

CONTROLLING THE PAPER LAYOUT: SPECIFIC PROPERTIES

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

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 and rw.field
  • Customizing Reports JSPs

EXTENDING FUNCTIONALITY USING XML

  • Creating XML Report Definitions
  • Running and Debugging XML Report Definitions

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

EMBEDDING A GRAPH IN A REPORT

  • Adding a Graph to a Report
  • Selecting the Graph Type and Data
  • Adding Options
  • Customizing Web Graphs
  • The rw:graph Tag
  • Customizing Graphs

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

PL/SQL TRIGGERS

  • Types of Triggers in Reports
  • Trigger Code
  • Using Report Triggers
  • Using Data Model Triggers
  • Using Triggers
  • Event-Based Reporting

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

MAXIMIZING PERFORMANCE

  • Running Reports Using OracleAS Reports Services
  • Report Request Methods
  • Oracle Application Server Components
  • Enabling Single Sign-On Access
  • Running the Layouts
  • Running a Paper Report on the Web
  • Queue Manager

BUILDING REPORTS

  • 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

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 3 + 9? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter