Oracle Reports 10g: Build Reports Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 5 Days

Course details

Sophisticated graphical reports are possible with Oracle10g ODS Reports. This product is one of the most complex yet powerful graphical reporting tools available. With sufficient training, even some of the most complex reporting requirements can be satisfied using this tool. This course is presented in an intensive workshop format where participants absorb the complex topics of object hierarchies, frame hierarchies, field-level control of report output and many other subjects.

Prerequisites:

The course Oracle Database 10g: Introduction to SQL
The course Oracle Database 10g: Program With PL/SQL

Suggested Next Course

The course Introduction To Java Language Programming
The course Oracle AS Discoverer 10g: Create Queries & Reports

INTRODUCTION TO ORACLE10g ODS & REPORTS :

ABOUT ORACLE10g ODS
ABOUT THE ORACLE10g ENTERPRISE ARCHITECTURE
SMP
MORE ABOUT ORACLE REPORTS

INTRODUCING THE REPORTS BUILDER WIZARDS:

AN INTRODUCTION TO THE WIZARDS
WELCOME DIALOG WIZARD
REPORT WIZARD

REPORT WIZARD PRODUCTIVITY FEATURES :

RE-ENTERING THE WIZARDS
USING THE QUERY BUILDER TOOL

BUILDING MASTER-DETAIL REPORTS:

REPORTS BUILDER INTERFACE – THE REPORT EDITOR :

REPORTS BUILDER INTERFACE – THE OBJECT NAVIGATOR & PROPERTY INSPECTOR:

MORE ABOUT THE REPORTS BUILDER INTERFACE
USING THE OBJECT NAVIGATOR
WORKING WITH THE OBJECT NAVIGATOR
THE VIEW MENU
THE TOOLS MENU
ABOUT THE PROPERTY INSPECTOR

FIELD FORMATTING:

ABOUT FIELD FORMATTING
CHARACTER FORMATTING
PAPER LAYOUT FORMATTING
CONDITIONAL FORMATTING

THE GRAPH WIZARD:

ABOUT THE GRAPH WIZARD
COMPLETING THE GRAPH WIZARD FOR WEB OUTPUT
COMPLETING THE GRAPH WIZARD FOR PAPER OUTPUT
MODIFYING THE GRAPH

REPORTS BUILDER INTERFACE – THE FILE MENU:

USING THE FILE MENU
MODULE & SESSION CONTROL
REPORT DISTRIBUTION
MODULE ADMINISTRATION

REPORTS BUILDER INTERFACE – EDITING PREFERENCES:

DATA MODEL VIEW – ENHANCING PROTOTYPE REPORTS:

USING THE DATA MODEL VIEW
USING THE DATA WIZARD
WORKING WITH DATA MODEL VIEW OBJECTS

LAYOUT OBJECTS:

ABOUT THE LAYOUT OBJECTS
MORE ABOUT THE PAPER LAYOUT VIEW
WHAT ARE THE LAYOUT OBJECTS?
ADDING STANDARD OBJECTS
ADDING WEB PROPERTIES TO OBJECTS
THE REPORT BLOCK WIZARD

ADVANCED DATA MODELS – MULTI-GROUP & MULTI-BLOCK REPORTS:

ABOUT THIS REPORT
BUILDING THE REPORT
CUSTOMIZING THE LAYOUT & FILTERING DATA

ADVANCED DATA MODELS – MATRIX REPORTS:

ABOUT MATRIX REPORTS
DEFINING A MATRIX REPORT
CUSTOMIZING A MATRIX REPORT
NESTED MATRIX REPORTS

UTILIZING REPORT PARAMETERS :

WHAT ARE PARAMETERS?
SETTING PARAMETER VALUES

EMPLOYING PL/SQL:

MORE ABOUT PL/SQL & ORACLE REPORTS
REPORT LEVEL TRIGGERS
PROGRAM UNITS
PL/SQL LIBRARIES

USING TEMPLATE FILES:

ABOUT TEMPLATES
LAYOUT OBJECTS WITHIN TEMPLATES

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Oracle jobs in Ireland

Are you from Professional Training Solutions Ltd ? Claim your course!

Courses you can instantly connect with... Do an online course on Oracle starting now.