Course Description:

This lab-intensive course is designed to lead developers through the steps involved in developing a report. The course covers concepts involved in using the GUI report writer to build reports in various formats that can include buttons, multimedia and OLE2 objects.

Participants will cover how to…

• Create reports by accessing data from various data sources

• Create and modify basic tabular reports and high quality Web reports

• Create other report styles such as break reports and matrix reports

• 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

• Publish a report on the Web

• 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 Oracle Reports Services and tune reports

Who Needs to Attend:

Application developers, designers, analysts and technical support personnel, plus those who manage projects requiring these skills.

Prerequisites:

Oracle Foundation Classes (SQL Basics & PL/SQL Workshop) or equivalent experience.

Course Content:

INTRODUCTION TO ORACLE REPORTS

• Oracle Reports overview

• Working with Oracle reports on the client and the Web

• Report Builder, Synchronization, Help

RUN A REPORT ON THE CLIENT

• Paper Design Actions

• Web Layout Actions

• From the Command Line

• Pass a parameter to a report

• Generate Report Output

CREATING A TABULAR REPORTS

• Creating a tabular report

• The Report Wizard

• Report Choices and Style

• Data Source Type and Definition

• Displayed Fields in the report

• Add Summaries

• Modify Labels

• Report Templates and Viewer

CREATE MASTER-DETAIL REPORTS

• Create a Master Group, Query, Group Fields

• Create a detail group in the wizard

• Data Model for a single report, and a master detail report

• Layout for a group left report

• Create a Detail Group Manually

• Data Model for a Group Above Report

• Repeating Frames

• Page Number and Date/Time in a report

CREATE FORM LETTER REPORTS

• Create a Form Letter, Query, Text

• Add Boilerplate in the Layout

• Explore the Margin Section

• Import an Image

CREATE MAILING LABEL REPORTS

• Create Mailing Labels

• Create Mailing Label Query

• Add Boilerplate to Mailing Labels

• Repeat Frames in Multiple Directions

• Frame Property Inspector

CREATE FORM REPORTS

• Create a Form-Like Report

• Create Form Report Query and Labels

• Create a Field in the Paper Layout

• Field Property Inspector

• Toolbars in the Layout

• Create Report Documentation

CREATE DATA MODEL GROUPS

• Create a Query in the Data Model

• Query and Group Property Inspector

• Add a Group Filter

• Link Queries

• Create a PL/SQL Query, Create a PL/SQL Package and Query Function

• Ref Cursor Property Inspector

CREATE DATA MODEL COLUMNS

• Creating data model columns

• Summary columns

• Column Property Manager

• Create Grand Total and Formula Columns

• Placeholder columns

CREATE MATRIX REPORTS

• Creating a matrix report

• Add summaries to a matrix report

• Matrix report labels, output, data model, layout

• Create a matrix in the data model

• Create a Cross Product in the data mode

ENHANCE MATRIX REPORTS

• Creating a matrix group report

• Matrix group Query, rows, columns, cell fields, summaries, labels, data model, output, layout

• Create a nested matrix report

• Add matrix summaries in the data model

USING PARAMETERS

• System Parameter

• Create a BIND parameter

• Parameter Property Inspector

• Validation triggers

• Creating a lexical parameter

• Static list of variable

• BIND vs. Lexical

• Generate Parameter Form

• Parameter Form Editor, Size, at Runtime

CREATE OR MODIFY LAYOUT OBJECTS

• Create a Header and Trailer Page

• Formatting Data, Conditional Formatting

• Confine Mode OFF and ON

• FLEX Mode OFF and ON

• Select Parent Frame

• Print Objects Object Elasticity

• Page Breaks

• Multi-panel Reports

• Column Mode

• Create a Report Block

• Create Explicit Anchors

EMBED A GRAPH IN A REPORT

• The Graph Wizard

• Select the graph type and position the graph

• Choose the X or Y axis

• Graph Layout, titles, legend, options, output, property inspector, hyperlinks

USING PL/SQL IN REPORTS

• Understanding PL/SQL

• Pre-defined packages and exceptions

• PL/SQL functions in triggers

• Creating and attaching external PL/SQL

• PL/SQL trace and debug features

CREATE REPORTS FOR THE WEB

• JSP, JSP Tags

• Web Source

• Create a Bookmark

• Generate HTML and PDF Output

• Adding HTML Header or Footer

• Creating Hyperlinks

• Report Escapes

RUN A REPORT ON THE WEB

• Environment Variables

• Static and Dynamic Reporting

• Three-tier Architecture

• How to Deploy a Report

• Test a report on the client

• The Report in a Web Browser

CREATE REPORT TRIGGERS

• Five Report Triggers

• PL/SQL Block Structure

• Create a Procedure or Function

• Create and view a Report Trigger

• Create and store code in a PL/SQL Library, attach a PL/SQL Library

• Stored Procedures vs. Library

CREATE OTHER REPORT TRIGGERS

• Group Filter Triggers

• Validation Triggers

• Format Triggers on Fields and Frames

THE SRW PACKAGE

• Send a message

• Run a report in the background

• Set field values

• Perform SQL statements

• Set Formatting

USE XML IN ORACLE REPORTS

• Generate XML Output

• Report Definition Tags

• Partial and Complete XML Report

• Run an XML Report

• Apply and XML Format

USE THE REPORT QUEUE MANAGER

• Report Services

• Report Queue Manager

• Schedule a Report Job