Module V

Course Topics:

·        Introduction to Oracle Reports

·        What is Business Intelligence?

·        Enterprise Reporting

·        What is Report Builder?

·        Where Does Oracle Developer Fit In?

·        Report Builder Components

·        Getting Started in the Oracle Reports Interface

·        Customizing Your Oracle Reports Session

·        Introducing the Course Application

·        Designing and Running Reports

·        Designing Reports

·        Understanding the User Requirements

·        Choosing the Report Style

·        Retrieving and Sharing Data

·        Running a Report

·        Viewing the Report Output

·        Report Builder Concepts

·        Reports Executables

·        Types of Report Builder Modules

·        Report Builder Components

·        Object Categories

·        Creating Reports Using the Report Wizard

·        Invoking the Report Builder

·        Creating a Tabular Report Using the Report Wizard

·        Modifying a Report Using the Report Wizard

·        Adding Summaries

·        Creating Mailing Labels

·        Creating Letters

·        Web-Enabling a Report Using the Web Wizard

·        Publishing and Viewing a Report on the Web

·        Enhancing a Report in the Live Previewer

·        What is the Live Previewer?

·        Modifying a Report in the Live Previewer

·        Aligning Columns

·        Setting Format Masks

·        Manipulating Objects

·        Changing Text and Modifying Visual Attributes

·        Creating Format Exceptions

·        Inserting Page Numbers, Current Date, and Time

·        Managing Report Templates

·        The Reports Template Editor

·        Modifying a Predefined Template

·        Adding Web Links to a Template for HTML Output

·        Registering a Customized Template

·        Reports Storage Methods

·        Storage Methods and Requirements

·        Sharing Reports Among Developers

·        Converting Between Storage Types

·        Documenting Reports

·        File Types and Portability

·        Enhancing Reports Using the Data Model: Creating Queries and Groups

·        The Data Model Objects

·        Changing the Group Structure

·        Ordering Data in a Group Using the Break Order Property

·        Eliminating Data Using Group Filters

·        Adding New Data

·        Linking Data from Different Queries Using a Data Link

·        Enhancing Reports Using the Data Model: Creating Columns

·        Maintaining Database Columns

·        Using a Database Column

·        Creating Summary Columns

·        Creating Formula Columns

·        Creating Placeholder Columns

·        Enhancing Reports Using the Layout Model

·        The Three-Report Sections

·        Report Bursting

·        Creating a Multipanel Report for Large Sets of Data

·        The Layout Model Objects

·        Creating Variable-Length Vertical Lines

·        Displaying a Video Clip Using a Button

·        Implicit and Explicit Anchors

·        Positioning One Object Relative to Another Using an Explicit Anchor

·        Modifying Common Layout Properties

·        Web Support for Layout Objects

·        Using Format Triggers

·        Modifying Web Setting Properties

·        Modifying Specific Layout Properties

·        Controlling the Print Direction of a Repeating Frame

·        Controlling Pagination of a Repeating Frame

·        Controlling Spacing Between Records

·        Creating New Fields in the Layout and Modifying the Properties

·        Creating a Link File to Display File Contents

·        Using Report Parameters and Customizing a Parameter Form

·        Creating User Parameters

·        Referencing User Parameters

·        Creating Lists of Values for Parameters

·        Referencing System Parameters

·        Creating a Parameter Form Layout

·        Customizing the Parameter Form Layout

·        Creating Parameter HTML Extensions

·        Embedding a Chart in a Report

·        Creating and Embedding a Graphics Chart Using the Chart Wizard

·        Embedding an Existing Graphics Chart in a Report

·        Restricting Chart Data with a User Parameter

·        Passing Report Data to the Chart

·        Creating Chart Hyperlinks

·        Enhancing Matrix Reports

·        The Matrix Data Model

·        The Matrix Layout Model

·        Creating Matrix Summaries

·        Creating a Nested Matrix Report Using the Wizards

·        Coding PL/SQL Triggers in Reports

·        Trigger Types

·        Creating Report Triggers

·        Creating Data Model Triggers

·        Creating Layout Model Triggers

·        Writing Common Code

·        Building Reports for the Web

·        Static Web Reporting

·        Dynamic Web Reporting

·        Building Web Drill-Down Reports

·        Using the Report Builder Built-In Package

·        Contents of the Report Builder Built-in Package

·        Outputting Runtime Messages

·        Managing Temporary Tables

·        Modifying Visual Attributes Dynamically

·        Controlling the Printer Output Dynamically

·        Suppressing Buttons in the Previewer Window Dynamically

·        Customizing Reports at Runtime

·        Building Reports Using XML

·        Applying Runtime Customizations

·        Applying Batch Updates

·        Using the Reports Server

·        Why Use a Remote Server?

·        Reports Server Architecture and Configuration

·        Viewing and Scheduling Reports in the Queue Manager

·        Controlling User Access