Develop the skills to effectively utilize the GUI report writer to build reports

Print Outline in PDF format

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 which can include buttons, multimedia and OLE2 objects.

Participants will learn…

• Reports 6 Concepts and Objects

• To use the Object Navigator

• To use the Report Painters

• OLE objects

• Basic Report Formats

• Using Build-In Packages

• Report Triggers

• Character Mode executions

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 & SQL Plus and PL/SQL Workshop) or familiarity with SQL and PL/SQL or equivalent experience.

Course Content:

INTRO TO REPORT BUILDER

• Oracle Reports overview

• Working with Oracle reports

CREATING A TABULAR REPORT

• Creating a tabular report

USING THE OBJECT NAVIGATOR

• Understanding objects

• The Object Navigator

• Understanding the Object Navigator

• Working with object property palettes

USING THE DATA MODEL EDITOR

• Invoking the data model editor

• Understanding the data model objects

• Using the data model tools

• Customizing the painting region

• Building a data model manually

• Finishing with the report wizard

USING THE LAYOUT EDITOR – PART 1

• Using the layout model editor

• Understanding editor objects

• Using layout editor tools

• Basic report formatting

• Layout sections

• Setting object print options

• Manipulating objects

USING THE LAYOUT EDITOR – PART 2

• Setting report properties

• Controlling text spacing and alignment

• Using the drawing tools

• Importing files

• Adding linked files

• Adding OLE2 objects

• Adding buttons

• Exporting files

• Creating frames

• Anchoring objects

BUILDING ADVANCED REPORTS-PART 1

• Building mailing label reports

• Building form letter reports

BUILDING ADVANCED REPORTS-PART 2

• Building break reports

• Building master-detail reports

USER-DEFINED COLUMNS

• Creating user-defined columns

• Formula columns

• Summary columns

• Placeholder columns

BUILDING MATRIX REPORTS

• Matrix report concepts

• Creating a matrix report

• Building a matrix report

• Creating a break matrix report

USING PARAMETERS

• Parameter concepts

• The runtime parameter form

• Working with user parameters

• Validating parameters

• Creating a lexical parameter

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

WEB REPORTING

• Creating static Web reports

• Manually generating Web report HTML files

• Viewing Web reports with a Web Browser

• Adding HTML Headers and Footers to your Web report

• Adding Bookmarks to your report

• Creating Hyperlinks

• Enabling Dynamic Web reporting

Course Labs:

1. Introduction to Report Builder

2. Creating a tabular report

3. Using the object navigator

4. Using the data model editor

5. Using the layout editor, part 1

6. Using the layout editor, part 2

7. Building advanced reports, part 1

8. Building advanced reports, part 2

9. User-defined columns

10. Matrix reports

11. Using parameters

12. Web Reporting