Learning Oracle Reports 2.5
Table of Contents
Chapter 1: Getting Started
- Starting Oracle Reports
- Quitting Oracle Reports
- The Starting Screen
- About Oracle Reports
- The Object Navigator
- The Oracle Reports Designer Window
- Report Parts
- Creating a New Report
- Tools and Icons
Chapter 2: A Tabular Report
- The Data Model Editor
- Entering the SQL Statement
- Default Layouts
- The Layout Editor
- Saving Your Work
- How Reports Finds Files
- Applying Format Masks
- Common Properties
- Generating the Runtime Module
- Running A Report
- Running the Report From the Command Line
Chapter 3:
A Break Report
Chapter 4: Mailing Labels
- The SQL Statement
- The Default Layout
- Testing the Report
- A Table Design for Addresses
- Format Triggers
- Sizing the Labels
- Printing Report Output
Chapter 5: A Matrix Report
- One Query Matrix Report
- Justifying a Character Field
- Three Query Matrix Report
Chapter 6: A Form Letter
- The Data Model
- The Default Layout
- Adding the Letter Text
- Displaying the Text
Chapter 7: A Master-Detail Report
- The Data Model
- Creating the Master-Detail Link
- Errors and Help
- Data Link Properties
- Fonts and Formatting
- Page Breaks
Chapter 8: Boilerplate Objects and Fields
- Margins and Titles
- Setting Field Attributes
- Adding Date and Page Number Fields
- Sizing Objects
- Page Breaks
- Adding Summary Fields
- Reverting to a Previous Version
Chapter 9: 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 Default Parameter Form
Chapter 11: Matrix Report. Part II
- Summarizing the Columns
- Adding a Grid
- Conditional Highlighting
- Getting Help on PL/SQL Packages
Chapter 12: Mail Merge and Barcodes
- The Data Model
- Margins and Body
- Adding the Barcode Graphic Object
- Rotating Text
- Print Conditions
- Anchoring the Barcode
- The Back of the Envelope
- Modifying the Parameter Form
- More Information
Chapter 13: Working With Oracle Graphics
- Starting Oracle Graphics
- Quitting Oracle Graphics
- The Starting Screen
- About Oracle Graphics
- Creating a Line Chart
- Creating a Pie Chart
- Adding the Pie Chart to a Report
- Adding the Line Chart to a Report 1
- Sizing Objects
- Mapping the Report Columns
- Testing the Changes
Chapter 14: Libraries, 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