List of Figures
- 1-1 Example matrix report
- 1-2 Matrix data models
- 1-3 Conceptual matrix
- 1-4 Matrix data model relationships
- 1-5 Sample nested matrix report
- 1-6 Matrix summary settings
- 1-7 Matrix summary settings
- 1-8 Matrix summary settings
- 1-9 Matrix Layout Model view
- 1-10 Formatting the same data in different ways
- 1-11 Unrelated queries
- 1-12 Sample data link
- 1-13 Sample data link output
- 1-14 Repeating frame sizing
- 2-1 Report dimensions
- 2-2 Sample matrix with group and nested matrix report
- 2-3 Default master/detail and group report that query same data
- 2-4 Master/detail/detail report
- 2-5 Parent object above child object
- 2-6 Parent object to the right of child object
- 2-7 Object in push path of two other objects
- 2-8 Delimited output of A above B
- 2-9 Delimited output of frame enclosing repeating frame
- 2-10 Delimited output of two frames enclosing repeating frames
- 2-11 Delimited output of boilerplate outside matrix
- 3-1 Example matrix object
- 4-1 Final output of the tabular report example
- 4-2 Final output of the mailing label report example
- 4-3 Final output of the form letter example
- 4-4 Final output of the first master/master report example
- 4-5 Final output of the second master/master report example
- 4-6 Final output of the summary report example
- 4-7 Final output of the single-query group report example
- 4-8 Final output of the two-query group report example
- 4-9 Final output of the across group report example
- 4-10 Final output of the group left summary report example
- 4-11 Final output of the group left formula report example
- 4-12 Final output of the wrapped field report example
- 4-13 Final output of the header and footer report example
- 4-14 Final output of the header with database values report example
- 4-15 Final output of the graphics, text, and color example
- 4-16 Final output of the renumbering pages by repeating frame example
- 4-17 Final output of the intermixed fields report example
- 4-18 Final output for the suppressing labels example
- 4-19 Final output for the first conditional form letter report example
- 4-20 FInal output for the second conditional form letter report example
- 4-21 Final output of the conditional highlighting report example
- 4-22 Final output of the dynamic graphics report example
- 4-23 Final output of the matrix report example
- 4-24 Final output of the nested matrix report example
- 4-25 Final output of the matrix with group above report example
- 4-26 Final output of the time series calculations report example
- 4-27 Final output of the Microsoft Excel report
- 4-28 Final output of the aggregate data report example
- 4-29 Final output of the check printing report with spelled-out cash amounts
- 4-30 Final output of the preprinted forms example
- 4-31 Final output of the invoice report example
- 4-32 Final output of the ranking report example
- 4-33 Simple table of contents
- 4-34 Index
- 4-35 Multilevel table of contents
- 4-36 Multibyte character set UTF8 report in Japanese
- 4-37 Final output of the PL/SQL report example
- 4-38 Final output for the REF CURSORs example
- 4-39 JSP Parameter Form
- 4-40 JSP-based Web report based on a user parameter
- 4-41 Final output of the barcode report with paper layout
- 4-42 Final output of the barcode report with Web layout
- 4-43 Final output of the XML PDS example
- 4-44 Final output for the text PDS example
- 4-45 Final output for the OLAP PDS example
- 4-46 Final output for the Express data example
- 5-1 Tabular report output
- 5-2 Paper Design view for the tabular report
- 6-1 Mailing label report output
- 6-2 Paper Design view for the mailing label report
- 6-3 Final mailing label report with vertical spacing
- 7-1 Form letter report output
- 7-2 Paper Design view for the form letter report
- 8-1 Master/Master report output
- 8-2 Data model with two unrelated queries
- 8-3 Paper Design view for the Master/Master report
- 8-4 Paper Layout view with two layouts and white space added
- 8-5 Paper Design view with monetary values formatted
- 9-1 Summary report output
- 9-2 Groups page of the Report Wizard
- 9-3 Totals page of Report Wizard
- 9-4 Summary report output with monetary values formatted
- 9-5 Summary report with report total formatted
- 10-1 Group report output
- 10-2 Groups page of the Report Wizard
- 10-3 Fields page of the Report Wizard
- 10-4 Paper Design view for the single-query group left report
- 10-5 Salaries formatted
- 10-6 Property Inspector for master repeating frame
- 10-7 Paper Design view after white space is added
- 10-8 Group left report output with two break columns
- 10-9 Data model with two break columns
- 10-10 Group left report output with two break groups
- 11-1 Group above report output, two queries
- 11-2 Two-query data model without a link
- 11-3 Two-query data model with a data link
- 11-4 Fields page of the Report Wizard
- 11-5 Paper Design view for the two-query group report
- 11-6 Group above report output with monetary values formatted
- 12-1 Across group report output
- 12-2 Data Model for Query 1
- 12-3 Data Model of the two linked queries
- 12-4 Paper Layout view for the across group report
- 12-5 Paper Design View of the Across Group Report
- 13-1 Group left summary report output
- 13-2 Groups page of the Data Wizard
- 13-3 Two-query data model with summaries
- 13-4 Two-query data model with a data link
- 13-5 Fields page of Report Wizard
- 13-6 Paper Design view for the group left layout with two group columns
- 13-7 Paper Layout view with two layouts
- 13-8 Paper Layout view with two layouts merged into one
- 13-9 Paper Design view with two layouts merged
- 13-10 Combined group left and tabular report output
- 14-1 Formula report output
- 14-2 Paper Design view for the formula report
- 14-3 Data Model of the Formula Report
- 14-4 Data Model with Formula Columns
- 14-5 Final formula report output
- 15-1 Wrapped field report output
- 15-2 Data Model for the query
- 15-3 Data model with groups
- 15-4 Data model with new G_Name group
- 15-5 Data Model with Three Summary Columns
- 15-6 Paper Design view for the wrapped field report
- 15-7 Paper Design view for the wrapped field report
- 16-1 Group left report output with header and footer
- 16-2 Group left report output with footer for master repeating frame
- 16-3 Group left report output with summary closer to label
- 16-4 Group left report output with page heading
- 16-5 Group left report output with values formatted
- 17-1 Group left report output with database values in header
- 17-2 Group left report output with values formatted
- 17-3 Data Model with Summary Columns for Header
- 17-4 Group left report output with database values in the header
- 18-1 Graphics, text, and color report output
- 18-2 Paper Design view for the graphics report with one query
- 18-3 Paper Layout View of Adjusted Report Layout
- 18-4 Paper Layout View with Expanded Repeating Frame
- 18-5 Paper Layout View with Expanded R_G_DEPARTMENT_ID Repeating Frame
- 18-6 Preview of the Report with a Border
- 18-7 Paper Design View of the Report with New Fonts
- 18-8 Paper Design View of the Report with Bullets
- 18-9 Paper Layout View with Line Separator
- 18-10 Paper Design View of Report with Line Separator
- 18-11 Paper Design View of Report with Title
- 19-1 Pages renumbered by repeating frame report output
- 19-2 Selecting group fields in the Report Wizard
- 19-3 Specifying labels and widths in the Report Wizard
- 19-4 Report layout in the Paper Design view
- 19-5 Revised report layout in Paper Design view
- 19-6 Page number source fields in top margin of report
- 19-7 Page number source and reference fields in top margin of report
- 19-8 Final pages renumbered by repeating frame report output
- 20-1 Group with master record in the middle of report output
- 20-2 Group page of Report Wizard
- 20-3 Paper Design view for intermixing fields report
- 20-4 Paper Design view of the intermixing fields report
- 20-5 Output displayed in Paper Design view
- 20-6 New Program Unit dialog box
- 20-7 Final report output displayed in the Paper Design view
- 21-1 Suppressed labels report output
- 21-2 Data Model view of the Suppress Labels report
- 21-3 Data Model view with formula and summary columns
- 21-4 Paper Design view for the suppress labels report
- 21-5 Navigating to M_G_DEPTNO1_HDR
- 21-6 Selected objects in the Object Navigator
- 21-7 Selected objects brought forward in the Object Navigator
- 21-8 Final Paper Output of the Suppressing Labels Report
- 22-1 Conditional form letter report output, base version
- 22-2 Conditional form letter report output, alternate version
- 22-3 Property Inspector with anchor properties displayed
- 22-4 Paper Layout view of modified report
- 23-1 Conditional highlighting report output
- 23-2 Paper Design view for the initial tabular report
- 23-3 Formatted salary column
- 23-4 Paper Design view of the tabular report
- 23-5 Format Exception dialog box
- 23-6 Conditional Formatting dialog box
- 23-7 FInal Conditional Formatting report
- 23-8 PL/SQL code for the new format triggers
- 24-1 Dynamic graphics report output
- 24-2 Data Model view for the dynamic graphics report
- 24-3 Initial Paper Layout view for the dynamic graphics report
- 24-4 Paper Layout view of the modified layout
- 24-5 Final Dynamic Graphics Report
- 25-1 Matrix report output
- 25-2 Paper Design view for the matrix report
- 25-3 Three query data model, queries unrelated
- 25-4 Three query data model with cross product group
- 25-5 Three query data model with cross product group and data links
- 25-6 Groups page of the Report Wizard
- 25-7 Fields page of the Report Wizard
- 25-8 Paper Design view for the matrix report
- 25-9 Matrix report in Paper Design view with monetary values formatted
- 25-10 Object Navigator with new object selected
- 25-11 Object Navigator with repeating frame and field selected
- 25-12 Matrix report output with zeroes replacing blanks
- 25-13 Matrix report output with a grid
- 26-1 Nested matrix report output
- 26-2 First matrix row in the Report Wizard
- 26-3 Second matrix row in Report Wizard
- 26-4 Paper Design view for the nested matrix report
- 26-5 Data model with four queries
- 26-6 Data Model with four queries and a cross product group
- 26-7 Nested matrix data model
- 26-8 Groups page of the Report Wizard
- 26-9 Fields page of the Report Wizard
- 26-10 Paper Design view for the nested matrix output
- 26-11 Data model with three queries
- 26-12 Data Model with three queries and a cross product group
- 26-13 Nested matrix data model
- 26-14 Groups page of the Report Wizard
- 26-15 Fields page of the Report Wizard
- 26-16 Paper Design view for the final nested matrix report output
- 26-17 Nested matrix report output with formatted monetary values
- 27-1 Matrix with group above report output
- 27-2 Paper Design view for matrix with group above report
- 27-3 Matrix with group above report output with summary labels
- 27-4 Layout model with lines above column summaries
- 27-5 Matrix group above report output with added space
- 28-1 Time series calculations report output
- 28-2 Paper Design view of the Time Series Calculations report
- 28-3 Data Model view of the Time series Calculations report
- 28-4 Time Series Calculations JSP-based Web Report
- 29-1 Spreadsheet report output
- 29-2 Paper design output
- 29-3 Web design output
- 29-4 Microsoft Excel output of your report
- 30-1 Aggregate data report output
- 30-2 Paper Design view for the aggregating data report
- 30-3 Paper Layout view of the Aggregating Data report
- 30-4 Paper Layout view with new boilerplate text
- 30-5 Paper Design view
- 30-6 Data Model for the aggregating data report
- 30-7 Aggregating Data JSP-based Web Report
- 31-1 Check printing report output
- 31-2 Paper Design view of the simple report
- 31-3 PL/SQL Editor displaying the SPELL function
- 31-4 Object Navigator with SPELL PL/SQL function
- 31-5 Data Model view
- 31-6 Resized Data Model view
- 31-7 Data Model with SPELLED_AMOUNT formula column
- 31-8 Data Model with two queries
- 31-9 Data Link between two queries
- 31-10 Paper Layout view of your report
- 31-11 Paper Layout view with resized margin
- 31-12 Partial Paper Layout view with F_ORDER_TOTAL1
- 31-13 Partial Paper Layout view with F_ORDER_DATE1
- 31-14 Partial Paper Layout view with F_CUSTOMER_NAME1
- 31-15 Partial Paper Layout view with F_CHECK_NO1 and F_CHECK_NO2
- 31-16 Partial Paper Layout view with F_1 field
- 31-17 Partial Paper Design view of the check report
- 31-18 Amount area on blank check
- 31-19 Check image with fields positioned
- 31-20 Formatted Check
- 31-21 Partial Paper Design view of the check report with horizontal guideline
- 31-22 Partial Paper Design view of the check with Order No. boilerplate text
- 31-23 Order No. and F_ORDER_ID fields in the Paper Design view
- 31-24 Order Date field in the Paper Design view
- 31-25 F_ORDER_DATE1 field next to Order Date text
- 31-26 Partial check stub in Paper Design view
- 31-27 Second vertical guideline in the Paper Design view
- 31-28 Customer field in the Paper Design view
- 31-29 Customer and F_CUSTOMER_NAME1 fields
- 31-30 Partial check stub in the Paper Design view
- 31-31 Formatted check stub
- 31-32 Check printing report with non-formatted order details
- 31-33 Final check report with spelled-out cash amounts and stub
- 32-1 Printing reports on preprinted forms
- 32-2 Data Model view of the first query
- 32-3 Data Model view with two queries
- 32-4 Data Model view of the linked queries and break group
- 32-5 Complete Data Model view of the preprinted forms example
- 32-6 Paper Layout view of the initial layout
- 32-7 Report Block boilerplate object in the Object Navigator
- 32-8 Paper Layout view of the preprinted form example with mailing label and order item details
- 32-9 Selected frame in the Object Navigator
- 32-10 Selected repeating frame in the Paper Layout view
- 32-11 F_PAGE_TOTAL and F_ORDER_TOTAL fields in the Paper Layout view
- 32-12 Final preview of your preprinted form report
- 32-13 Final report printed on a sample preprinted form
- 32-14 Paper Design view of the preprinted form report with page numbers
- 33-1 Invoice report output
- 33-2 Queries in the Data Model view
- 33-3 Data Model view with data link, summary, and formula columns
- 33-4 Invoice report layout
- 33-5 Final invoice report output
- 34-1 Tabular report output, ranked by number and percentage of customers
- 34-2 Paper Design view for the ranking report
- 34-3 Tabular report output restricted to top three customers
- 34-4 Tabular report output with parameter value displayed
- 34-5 Data Model view of the Ranking Report
- 34-6 Tabular report output restricted by number and percentage of customers
- 35-1 Simple table of contents for a large report
- 35-2 Simple index for a large report
- 35-3 Simple table of contents
- 35-4 Data model for the group above report
- 35-5 Paper Layout view of the group above report
- 35-6 Data model with second query
- 35-7 Paper Layout view of the Header Section
- 35-8 Table of contents page of the report
- 35-9 Results for customers in Argentina
- 35-10 Sample index for the paper report
- 35-11 Data model view of the index
- 35-12 Index page of the report
- 36-1 Multilevel table of contents
- 36-2 Main category with sub-category sample page in the report
- 36-3 Data model for the multilevel TOC report
- 36-4 Paper Layout view of the Header Section
- 36-5 Table of contents page of the report
- 36-6 Results for the BOYS product department and SHIRTS sub-category
- 37-1 Deleting the repeating frame
- 38-1 Output of the multibyte character set UTF8 report in Japanese
- 38-2 Output of the same multibyte character set UTF8 report in Polish
- 38-3
uifont.ali
file edited to include the TrueType font file name
- 38-4 Paper design view of the report without Japanese characters in default setting
- 38-5 Paper design view of the report with Japanese characters
- 38-6 Paper design view of the report with Polish characters
- 38-7 PDF file of the report with Polish characters
- 39-1 PL/SQL report output
- 39-2 Object Navigator
- 39-3 Data Model view of the PL/SQL report
- 39-4 Data Model with expanded G_FIRST_NAME
- 39-5 Data Model with unnamed formula column
- 39-6 Data Model with BONUS formula column
- 39-7 Object Navigator with FINAL_CALC function
- 39-8 Data Model with BONUS and TOTAL_COMP formula columns
- 39-9 Displays Fields list
- 39-10 Paper Layout view of the PL/SQL example report
- 39-11 Object Navigator with M_NAME repeating frame
- 39-12 Paper Design view of modified report
- 39-13 User Parameter in the Object Navigator
- 39-14 Data Model with new summary column
- 39-15 Layout with added vertical space
- 39-16 Final PL/SQL example report
- 40-1 REF CURSOR report output
- 40-2 Overview of the REF CURSOR example
- 40-3 Data model with three queries
- 40-4 Query with group
- 40-5 Data model with group
- 40-6 Data model with links
- 40-7 Data model with summary columns
- 40-8 Paper Design view for the REF CURSOR report
- 41-1 JSP Parameter Form
- 41-2 JSP-based Web report based on a user parameter
- 41-3 Sample HTML Parameter Form
- 41-4 Data Model view of the Parameter Form
- 41-5 Parameter form with values
- 41-6 JSP Parameter Form with selections
- 41-7 Sample employee report based on user parameters
- 42-1 Barcode JavaBean Web report output
- 42-2 Data Model for the query
- 42-3 Data Model with two new formula columns
- 42-4 Paper Design view of the barcode paper report
- 42-5 Data Model for the JSP-based Web report query
- 42-6 Data Model with the three formula columns
- 42-7 Snapshot of the final JSP-based Web report with barcode
- 44-1 Report output using an XML PDS
- 44-2 Data Model for the XML PDS example SQL query
- 44-3 Data model for the XML PDS example with XML and SQL queries
- 44-4 Data Model with a data link between a SQL query and an XML query
- 44-5 Paper Design view for the XML PDS report
- 44-6 XML PDS Report with Alternating Row Colors
- 44-7 Data Model with Group Hierarchy
- 44-8 Final Paper Design view of the XML PDS example report
- 45-1 Report output using a Text PDS
- 45-2 Snapshot of the textpds.conf entry
- 45-3 Paper Design view for the Text PDS report
- 46-1 Report output using an OLAP PDS
- 46-2 Connect (OLAP Data Source) dialog box
- 46-3 Connection Editor tab
- 46-4 OLAP Connection tab
- 46-5 OLAP Query Wizard Welcome page
- 46-6 Items page
- 46-7 Choose Divisions page
- 46-8 Choose Lines page
- 46-9 Choose Times page
- 46-10 Output of matrix report based on OLAP data
- 46-11 Paper Design view of the report with formatting
- 46-12 Final Paper Design view of the OLAP PDS example report
- 47-1 Express report output
- 47-2 Express Query dialog box
- 47-3 Matrix Group Fields
- 47-4 Paper Design view for the Express report
- 47-5 Paper Design view for the Express report
- 47-6 Summary column data model
- 47-7 Custom Measures Expression
- 47-8 Paper design output
- A-1 Main toolbar
- A-2 Data Model view tool palette
- A-3 Paper Layout view tool palette