Oracle Reports 10g Build Reports 1-4188-1121-1 Study Guide

1-4188-1121-1 © 2005 Publish date: December 9, 2004 569 pages

Buy Now: $299.99

Course ID: oracle-rep-build-rep-sg

Master building reports using one of the most complex and powerful graphical reporting tools on the market, Oracle10g ODS Reports, by choosing the Oracle Reports 10g Build Reports study guide.

CBT Planet offers numerous Oracle computer training books designed to give you real-world skills using a self-paced approach. You can use the course as a standalone teaching tool or you can use it along with other Oracle courses as a helpful supplement.

The Oracle Reports 10g Build Reports courseware uses an intensive workshop format presenting a variety of complex topics including frame hierarchies, object hierarchies, field-level controlling of report output, and numerous related topics.

This course is ideal for application developers and designers, and managers who will be using the Oracle reports product for developing Internet applications. You can learn how to build reports without taking time off of your hectic job in order to accomplish your goals. Take the learning at your own pace and prepare yourself for success.

By choosing the Oracle Reports 10g Build Reports courseware, you will learn about Oracle10g enterprise architecture, the reports builder wizards, creating master-detail reports, Object Navigator and Property Inspector, formatting fields, the graph wizard, working with the Reports builder interface, data model view, layout objects, advanced data models including multi-group and multi-block reports, Matrix reports, report parameters, and using PL/SQL.

Course Contents

An introduction to Oracle10g ODS and reports

• Overview of Oracle10g enterprise architecture
• SMP
• Oracle reports

The reports builder wizards

• Wizards
• The Welcome dialog wizard
• The Report wizard

• Report wizard features for productivity 
• Re-entering the wizards
• The query builder tool

Creating master-detail reports

• Working with the report editor

Object Navigator and Property Inspector

• Working with Object Navigator
• View menu
• Tools menu
• Working with Property Inspector

Formatting fields

• Formatting characters
• Formatting paper layouts
• Conditional formatting

Graph wizard

• Using the graph wizard for web output
• Using the graph wizard for paper output
• How to modify the graph

Reports builder interface: using the file menu

• Working with the file menu
• Module and session control
• Report distribution
• Module administration

Reports builder interface: working with editing preferences

Data model view

• Working with the data model view
• Working with the data wizard
• Using data model view objects

Layout objects

• Paper layout view
• Layout objects
• Standard objects
• Adding web properties to objects
• Working with the report block wizard

Advanced data models including multi-group and multi-block reports

• Building reports
• Customizing layouts and filtering data

Working with advanced data models

Matrix reports

• Matrix reports
• Customizing matrix reports
• Nested matrix reports

Report parameters

• How to set parameter values

Employing PL/SQL

• Report level triggers
• Program units
• PL/SQL libraries
• Working with template files
• Discussing templates
• Layout objects found inside templates