Oracle Reports 10g

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