Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 10g > Oracle Reports 10g: Build Reports Training

Oracle Reports 10g: Build Reports Training

Course#: WA1388

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

Objectives

Oracle Reports is one of the most functionally rich, and therefore complex, products available from Oracle Corporation. There is virtually no limit to the combination of options and features that can be used to produce reports. Within this course we seek to introduce you to this tool and explore some of the most commonly used techniques for publication of information.

The major objectives of this course are:

  • Consideration of the structure of Oracle Reports, the Oracle Development Suite (ODS) and the overall Oracle enterprise architecture.
  • Distribution of reports in all supported formats including HTML, HTML with embedded Java Server Pages, PDF and hardcopy.
  • Quickly building prototypes with the various wizards of the Oracle Reports Builder tool.
  • Customizing prototypes using the Report Editor.
  • Individual field formatting for both web and paper layout.
  • Advanced customization of the data model.
  • Advanced customization of the layout objects.
  • Utilizing specialty techniques such as parameters, reusable PL/SQL programs and template files.

Audience 

The target audience for this course is application developers and designers, as well as their management, who will be developing Internet applications using the Oracle Reports product.

Prerequisites

WA1373 Oracle Database 10g: Introduction to SQL
WA1475 Oracle Database 10g: Program With PL/SQL

Duration

Five days.

Outline of WA1388 Oracle Reports 10g: Build Reports Training

  1. INTRODUCTION TO ORACLE10g ODS & REPORTS  

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

  2. INTRODUCING THE REPORTS BUILDER WIZARDS  

  • AN INTRODUCTION TO THE WIZARDS
  • WELCOME DIALOG WIZARD
  • REPORT WIZARD

  3. REPORT WIZARD PRODUCTIVITY FEATURES

  • RE-ENTERING THE WIZARDS
  • USING THE QUERY BUILDER TOOL

  4. BUILDING MASTER-DETAIL REPORTS

  5. REPORTS BUILDER INTERFACE – THE REPORT EDITOR

  6. 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

  7. FIELD FORMATTING

  • ABOUT FIELD FORMATTING
  • CHARACTER FORMATTING
  • PAPER LAYOUT FORMATTING
  • CONDITIONAL FORMATTING

  8. THE GRAPH WIZARD

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

  9. REPORTS BUILDER INTERFACE – THE FILE MENU

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

  10. REPORTS BUILDER INTERFACE – EDITING PREFERENCES

  11. DATA MODEL VIEW – ENHANCING PROTOTYPE REPORTS

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

  12. 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  

  13. ADVANCED DATA MODELS – MULTI-GROUP & MULTI-BLOCK REPORTS

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

  14. ADVANCED DATA MODELS – MATRIX REPORTS

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

  15. UTILIZING REPORT PARAMETERS

  • WHAT ARE PARAMETERS?
  • SETTING PARAMETER VALUES  

  16. EMPLOYING PL/SQL

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

  17. USING TEMPLATE FILES

  • ABOUT TEMPLATES
  • LAYOUT OBJECTS WITHIN TEMPLATES
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.