Oracle Reports Developer
Build Reports
5 days training event
6100-3043
Learn to build complex and sophisticated reports from any data source, in any format, using Oracle Reports Developer (9.0.4.0.1). In this course, participants also learn to deploy the reports using
OracleAS Reports Services.
Learn To
In this course, participants learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer (9.0.4.0.1). Working in the declarative environment of Reports Builder, participants learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.
Participants learn how to add dynamic content to a static Web page and publish reports to the Web. In addition, participants learn how to customize more complex reports, embed graphical charts, and use OracleAS Reports Services to deploy the reports.
Audience
Technical Consultant
Reports Developer
Business Intelligence Developer
PL/SQL Developer
Course Objectives
Use report parameters and customize a runtime parameter form
Enhance reports using graphs and PL/SQL trigger code
Maximize report performance using OracleAS Reports Services and tune reports
Publish a report on the Web and build reports to run in various languages
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
Create and modify basic tabular reports and high quality Web reports
Create other report styles such as break reports and matrix reports
Create reports by accessing data from various data sources
Add dynamic data to an existing HTML page
Introduction to Oracle Reports Developer
OracleAS Reports Services
Oracle Reports Developer
OracleAS Reports Services Architecture for the Web
Oracle Database 10g
Oracle Application Server 10g
Enterprise Reporting
Business Intelligence
Oracle Developer Suite 10g
Designing and Running Reports
Matrix
Retrieving and Sharing Data
Tabular
Master-Detail
Master with Two Details
Running a Report
Designing Reports
Understanding User Requirements
Exploring Oracle Reports Developer
Reports Developer Executables
Reports Builder Modules
Reports Builder Components
Object Navigator
Invoking Reports Builder
Data Model Objects
Report Data and Layout
Report-Level Objects
Creating a Paper Report
Creating Break Reports
Building a Paper Report
Creating Mailing Labels and Letters
Break Report Labels
Report Module Components
Saving the Report Definition
Reentering the Wizard
Viewing the Paper Report Output
Enhancing a Basic Paper Report
Setting a Format Mask
Aligning Columns
Applying Conditional Formatting
Modifying Visual Attributes
The Paper Design Window
Modifying a Report
Manipulating Objects
What Is the Paper Design?
Managing Report Templates
Customizing the Template Margin
Predefining Your Own Templates
Adding a Template Preview Image
Adding Web Links to a Template for Report HTML Output
Modifying a Template
Using Report Templates
Customizing the Template Body
Creating a Web Report
JSP Advantages
JSP Tags
Simple JSP Example
Using the Report Wizard
Building a Web Report
Web Source Example
Report Editor: Web Source View
What Is JSP Technology?
Enhancing Reports Using the Data Model: Queries and Groups
Query Modifications
Group Hierarchy
Modifying Properties of a Query
Changing the Group Structure
The Data Model Objects
Applying Changes
Ordering Data in a Group
Filtering Data in a Group
Enhancing Reports Using the Data Model: Data Sources
Data Source Types
Using JDBC as a Data Source
OLAP Data Source
Using Text as a Data Source
Using XML as a Data Source
Document Type Definition File
Pluggable Data Sources
Using REF Cursor Queries
Enhancing Reports Using the Data Model: Creating Columns
Maintaining Data Source Columns
Creating a Formula Column
Data Model Columns
Creating Summary Columns
Displaying Percentages
Creating a Column
Displaying Subtotals
Producing File Content Output
Enhancing Reports Using the Paper Layout
Report Processing
Designing Multipanel Reports
Printing Multipanel Reports
Viewing the Paper Layout
The Paper Layout Layers
Different Objects in the Paper Layout
Report Bursting
Paper Layout Tools
Controlling the Paper Layout: Common Properties
Modifying Paper Layout Object Properties
Using Format Triggers
Anchors
Pagination Icons in the Paper Layout
Sizing Objects
Layout Object Relationships
Controlling Print Frequency
Common Layout Properties
Controlling the Paper Layout: Specific Properties
Specifying Print Direction
Properties of a Repeating Frame
System Variables
Displaying File Contents
Valid Source Columns
Controlling Spacing Between Records
Minimum Widow Records
Controlling the Number of Records per Page
Web Reporting
Examining the Web Source Code
Adding Dynamic Content
Creating a Report Block
rw:field Tag
Customizing Reports JSPs
rw:foreach Tag
Comparing Static and Dynamic Reporting
Invoking the Report Block Wizard
Extending Functionality Using XML
Full Report Definition: Data Model Modification Example
Running XML Report Definitions
Debugging XML Report Definitions
Partial Report Definitions: Format Exception Example
Creating XML Report Definitions
Partial Report Definitions: Format Modification Example
Why Use XML Report Definitions?
Creating and Using Report Parameters
Hints and Tips When Referencing Parameters
Building a Paper Parameter Form
Creating User Parameters
Creating a List of Values
Referencing System Parameters
Using Lexical References
Using Bind References
Referencing Parameters in a Report Query
Embedding a Graph in a Report
Adding a Graph to a Web Report
Customizing Graphs Using the Graph.XML File
Selecting the Graph Type
Customizing Web Graphs
Selecting the Graph Data
The rw:graph Tag
Adding Options to the Graph
Adding a Graph to a Paper Report
Enhancing Matrix Reports
The Matrix Data Model
Building a Nested Matrix
Creating the Matrix Manually
The Matrix with Group Data Model
The Matrix Paper Layout
Nested Matrix Paper Layout
Creating Matrix Summaries
The Matrix with Group Layout
Coding PL/SQL Triggers
Types of Triggers in Reports
Using Data Model Triggers: Parameter Validation
Using Layout Triggers
Using Report Triggers
Using Format Triggers
Using Data Model Triggers: PL/SQL Group Filter
Trigger Code
Event-Based Reporting
Extending Functionality Using the SRW Package
Creating a Table of Contents
Initializing Fields
Restricting Data
Contents of the SRW Package
Executing a Nested Report
Performing DDL Statements
Outputting Messages
Setting Format Attributes
Maximizing Performance Using OracleAS Reports Services
Report Request Methods
Running Reports Using OracleAS Reports Services
Oracle Application Server Components
Running a Paper Report on the Web
Running the Web Layout: JSP Run-time Architecture
Queue Manager
Enabling Single Sign-On Access
Running the Paper Layout: Servlet Run-time Architecture
Building Reports: Efficiency Guidelines
Different Development and Run-Time Environments
Investigating the Data Model
Developing Reports to Run in Different GUIs
Non SQL Data Sources
Tuning Reports
Investigating the Paper Layout
Running the Report
Performance Measurement
TRAINING LOCATIONS
أماكن ومقرات التدريب حول العالم
Dubai
Kuala Lumpur
Tunis
Istanbul
Amman
Sharm El Sheikh
Ottawa
Paris
Lagos
Harare
Kampala
Casablanca