Sample Chapter 

Topics 

 Place an Order

 Home

Related Links

Learning Oracle Report Builder 3.0

Table of Contents

Chapter 1: Getting Started

    Starting Report Builder
   Quitting Report Builder
   The Starting Screen
    About Report Builder
    The Object Navigator
    The Report Builder Designer Window
    Report Parts
    Creating a New Report
    Tools and Icons

Chapter 2: A Tabular Report

    The Report Wizard
    Ordering the Data
    The Live Previewer
    Format Masks
    Live Reformatting
    Saving Your Work
    How Report Builder Finds Files
    Compiling the Runtime Module
    Running A Report
    Running the Report From the Command Line

Chapter 3: A Break Report

    Reusing A Report
    Renaming the Query Object
    Creating the Break
    Default Layout
    Testing the Report
    Replacing the Format Masks
    Editing the Format Masks

Chapter 4: Mailing Labels

    The SQL Statement
    A Table Design for Addresses
    Format Triggers
    Sizing the Labels

Chapter 5: A Matrix Report

    One Query Matrix Report
    Formatting the Report
    The Attribute Box and Palettes
    Three Query Matrix Report

Chapter 6: A Form Letter

    The SQL Statement
    Entering the Text
    Modifying the Output

Chapter 7: A Master-Detail Report

    The Data Model
    Creating the Master-Detail Link
    Data Link Properties
    Fonts and Formatting
    Page Breaks

Chapter 8: Boilerplate Objects and Fields

    Margins and Titles
    Adding Date and Page Number Fields
    Setting Field Attributes
    Page Breaks
    Adding Summary Fields
    Reverting to a Previous Version

Chapter 9: A Drill Down Report

    Interactive Reports
    Creating a Button
    Putting Data in the Title
    Testing the Report

Chapter 10: Working With Parameter Forms

    Lists of Values
    The Parameter Form Builder

Chapter 11: A Matrix Report, Part II

    Adding a Grid
    Conditional Formatting
    Getting Help on PL/SQL Packages

Chapter 12: Mail Merge

    The Data Model
    Margins and Body
    Rotating Text
    Print Conditions
    The Back of the Envelope
    Modifying the Parameter Form

Chapter 13: Working With Oracle Graphics Builder

    Starting Graphics Builder
    Quitting Graphics Builder
    The Starting Screen
    About Graphics Builder
    Creating a Line Chart
    Creating a Pie Chart
    Adding the Pie Chart to a Report
    Adding the Line Chart to a Report
    Sizing Objects
    Mapping the Report Columns
    Testing the Changes
    The Chart Wizard

Chapter 14: Libraries, Packages, Triggers, and Formulas

    Packages
    Libraries
    Attaching A Library
    A Report Trigger To Use the Library
    A Formula to Calculate Portfolio Value
    Using the Formula's Return Value

Chapter 15: Publishing the Output

    The Web Wizard: HTML File Output
    The Web Wizard: PDF File Output

Chapter 16: Working with Templates

    Report Standards
    The Template Editor
    Importing Images
    Adding a Template to the Report Wizard List
    Testing the Template
    Adding a Sample Image to the Report Wizard List