About This Document

• Documentation Website
• How to Print the Document
• Documentation Conventions
• Contact Us!

1. Overview of Panther Reports

• Report Definition: A Composite View
• Report Wizard
• Data Access
• Automatic Calculations
• Modular Architecture
• Cross-Platform Portability
• Report Deployment

2. Introducing Report Layout

• Creating Layout Areas
• Managing the Layout Window
• How to Collapse and Expand Layout Areas
• How to Move Layout Areas
• How to Change Layout Area Dimensions
• Editing Layout Area Properties
• Populating Layout Areas
• Copying Widgets to a Layout Window
• Positioning Widgets

3. Introducing Report Structure

• Report Structure Window
• Node Classes and Types
• Node Hierarchy
• Editing the Report Structure
• How to Add a Node
• How to Delete or Remove a Node
• How to Copy a Node
• How to Paste a Node
• How to Move a Node
• How to Collapse and Expand the Structure View
• Editing Node Properties
• Viewing Node Links
• Going to a Property Link

4. Building a Sample Report

• Creating a Report
• Laying Out the Report
• Creating the Detail Layout
• How to Create the vbizplus.dic Repository
• How to Define the Detail's Layout Area
• How to Copy Repository Widgets into the Layout Area
• Defining the Page Header Layout
• How to Define the Page Header's Layout Area
• How to Create the Column Headings and Report Title
• How to Create a Date Widget
• Defining the Page Footer Layout
• How to Define the Footer with Page Number
• Building the Report Structure
• How to Print Page Header and Footer Data
• How to Fetch Data from a Database
• How to Print Detail Data
• How to Group Report Data
• Testing the Report
• Adding an Item to the Repository
• How to Add an Item to a Repository Entry
• Running the Report

5. Defining the Report Structure

• Defining a Report
• Named and Unnamed Reports
• Report Parameters
• Invoking Subreports
• How to Invoke a Subreport
• Setting Subreport Composition
• Using Caller Settings
• Calling Functions
• How to Create or Edit JPL Procedures in a Report File
• Processing One-Time Events
• Building Modular Reports
• Invoking External Report Files
• Including Report Files
• How to Include Report Files
• Included Versus External Files

6. Fetching and Grouping Report Data

• Connecting to a Database
• Using Multiple Database Engines
• Fetching Report Data
• Using Database Data
• Transaction Manager
• SQL SELECT Statement
• Named Cursors
• Fetching Bundle Data
• How to Fetch Bundle Data
• Using a Custom Function
• How to Fetch Data Using a JPL Procedure or C Function
• Outputting Detail Data
• Creating Groups
• Sorting Data
• Defining Groups
• Controlling Break Field Output
• Outputting Group Headers and Footers
• Outputting Summary Data Only
• Grouping All Report Data

7. Calculating Report Data

• Outputting Derived Values
• Totaling
• Group and Grand Totals
• Page Totals
• Copying
• Collecting
• How to Create a History Widget
• Using Historical Data in Graphs
• Viewing Property Links
• Going to a Property Link
• Outputting Database Calculations
• Using Call Nodes
• Calculating Widget Output
• Creating a Calculation Widget
• Initializing Calculated Data
• Updating Calculated Data
• Controlling Report Execution
• Using JPL Return Codes
• Setting Node Properties at Runtime
• Transferring Data from a Report
• Grouping Data on Computed Break Fields

8. Refining the Look

• Setting Page Format
• Page Format Properties
• Resetting Page Format
• Displaying Page Numbers
• Controlling Pagination
• Allowing Detail Page Breaks
• Controlling Group Pagination
• How to Keep Group Data Together on the Same Page
• How to Start a Group on Its Own Page
• How to Allow Breaks in Group Headers and Footers
• Keeping Subreport Output Together
• Forcing Page Breaks
• Inserting Blank Pages
• Generating Title and Trailer Pages
• How to Create a Title Page
• How to Create a Trailer Page
• Using Fonts
• Setting Fonts
• Defining Printing Font Aliases
• Positioning Output
• Reducing White Space
• Shrinking Layout Areas
• Shrinking Out Empty Lines
• Shrinking Arrays
• Consolidating Blank Space
• Adding Graphics
• Pixmaps
• Lines and Boxes

9. Running Reports

• Running Reports from the Report Menu
• Page Setup
• Windows Print Setup
• UNIX Print Setup
• Running Reports Outside the Editor
• How to Invoke a Report From the Command Line
• How to Invoke a Report From a JPL Procedure
• How to Invoke a Report From a C Function
• How to Invoke a Report From a URL
• Setting Invocation Options
• Remote Processing
• Initialization Options
• Driver Options
• Output Destination
• Warnings
• Format
• Range
• Windows Printer Driver Options
• Supplying Arguments
• Viewing Reports Onscreen
• How to Save Report Output to a Metafile
• Creating Dynamic Reports
• Calling Report Services in JetNet/Oracle Tuxedo
• Default Report Service and Unload Handler
• Custom Report Services
• Report Service Tasks
• Report Service Messages
• Example
• Handling Client Output
• Running Reports in a Web Browser
• Viewing Reports
• Debugging Reports

A. Report Utilities

• dev2bin
• rwrun

B. Reports Sample Database

• Vbizplus Schema

C. Report Device Configuration Files

• File Format
• Keywords

D. Report Output Procedures

• Arguments
• Return Values
• Invoking the Output Procedure

E. Sample Reports

• Example 1
• Generating Title and Trailer Pages
• Grouping Report Data
• Calculating Summary Data
• Example 2
• Example 3
• Example 4

F. Report Properties

• Report Structure Window
• Widgets
• Layout Window
• Widget Properties
• Report File Properties

Index