Skip Headers
Oracle® Reports Building Reports
10
g
Release 2 (10.1.2)
B13895-01
Library
Product
Index
Next
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documentation
Conventions
Accessing the Example Reports
Accessing the Data Sources
1
Basic Concepts
1.1
Reports Builder
1.1.1
About Reports Builder
1.1.2
About this release
1.2
Reports
1.2.1
About reports
1.2.1.1
Creating a new report using the Report Wizard
1.2.1.2
Creating a new report manually
1.2.2
About Web reports
1.3
Report Styles
1.3.1
About tabular reports
1.3.2
About group above reports
1.3.3
About group left reports
1.3.4
About form-like reports
1.3.5
About form letter reports
1.3.6
About mailing label reports
1.3.7
About matrix reports
1.3.7.1
Matrix data model
1.3.7.2
Matrix layout
1.4
Wizards
1.4.1
About the Report Wizard
1.4.2
About the Report Block Wizard
1.4.3
About the Data Wizard
1.4.4
About the Graph Wizard
1.5
The Object Navigator
1.5.1
About the Object Navigator
1.5.2
About Object Navigator views
1.6
The Report Editor
1.6.1
About the Report Editor
1.6.2
About the Data Model view
1.6.3
About the Paper Layout view
1.6.4
About the Paper Design view
1.6.5
About the Paper Parameter Form view
1.6.6
About the Web Source view
1.6.7
About the tool palette and toolbar
1.7
Data Model Objects
1.7.1
About queries
1.7.2
About groups
1.7.3
About database columns
1.7.4
About data links
1.7.5
About Query Builder
1.8
Layout Objects
1.8.1
About frames
1.8.2
About repeating frames
1.8.3
About frame and repeating frame sizing
1.8.4
About fields
1.8.5
About boilerplate objects
1.9
Parameter Form Objects
1.9.1
About parameters
1.9.2
About Parameter Form fields
1.9.3
About Parameter Form boilerplate
1.9.4
About Parameter Forms for Web reports
1.10
The Property Inspector
1.10.1
About the Property Inspector
1.10.1.1
About making multiple selections in the Property Inspector
1.11
Runtime Views
1.11.1
About the Runtime Parameter Form
1.11.2
About the Previewer
1.12
Executables
2
Advanced Concepts
2.1
Reports
2.1.1
About report titles
2.1.2
About report sectioning and sections
2.1.3
About the report unit of measurement
2.1.4
About the report dimensions
2.1.5
About fonts in reports
2.1.6
About conditional formatting
2.1.7
About nested matrix reports
2.1.8
About matrix with group reports
2.2
Web Reports
2.2.1
About JavaServer Pages (JSPs) and servlets
2.2.1.1
Using JSPs in Oracle Reports
2.2.1.2
Opening or running an encoded JSP-based Web report
2.2.1.3
Embedding a character set in a JSP file dynamically
2.2.2
About previewing JSP-based Web reports
2.2.3
About Web links for HTML output
2.2.4
About Web links for PDF output
2.2.5
About hyperlinks
2.2.6
About graph hyperlinks
2.2.7
About hyperlink destinations
2.2.8
About bookmarks
2.2.9
About application command line links
2.2.10
About before and after escapes
2.2.11
About style sheets
2.3
Data Model Objects
2.3.1
About summary columns
2.3.2
About formula columns
2.3.3
About placeholder columns
2.3.4
About referencing columns and parameters
2.3.4.1
About bind references
2.3.4.2
About lexical references
2.3.4.3
Differences between bind and lexical references
2.3.5
About non-linkable queries
2.3.6
About links versus groups
2.3.7
About matrix objects
2.4
Layout Objects
2.4.1
About layout objects
2.4.2
About layout defaulting
2.4.3
About images
2.4.4
About anchors
2.4.4.1
Implicit anchoring algorithm
2.4.5
About changing colors and patterns
2.4.6
About resizing objects
2.4.7
About moving and layering objects in the Paper Layout view
2.5
Parameter Form Objects
2.5.1
About Parameter Form HTML extensions
2.6
PL/SQL
2.6.1
About the PL/SQL Editor
2.6.2
About the Stored PL/SQL Editor
2.6.3
About the Syntax Palette
2.6.4
About program units
2.6.5
About stored program units
2.6.6
About external PL/SQL libraries
2.6.7
About attached libraries
2.6.8
About formulas
2.6.9
About group filters
2.6.10
About REF CURSOR queries
2.6.11
About DML and DDL
2.6.12
About built-in packages
2.6.12.1
About the Reports Builder built-in package (SRW)
2.6.12.2
About the Tools built-in packages
2.6.13
About triggers
2.6.13.1
About
report triggers
2.6.13.2
About format triggers
2.6.13.3
About validation triggers
2.6.13.4
About database triggers
2.7
Templates
2.7.1
About templates
2.7.2
About template attributes
2.7.3
About applying templates
2.7.4
About inheritance in templates
2.7.5
About the Template Editor
2.8
Output Formats and Capabilities
2.8.1
About format order
2.8.2
About batch reporting
2.8.3
About report distribution
2.8.3.1
About the DST file
2.8.4
About pluggable destinations
2.8.5
About event-driven publishing
2.8.6
About switching the printer tray
2.8.7
About XML in reports
2.8.8
About HTML and HTMLCSS output
2.8.8.1
About HTML page streaming
2.8.9
About HTML formatting
2.8.10
About PDF output
2.8.11
About RTF output
2.8.12
About delimited output
2.8.13
About spreadsheet output
2.8.14
About text output
2.8.15
About creating an ASCII (character-mode) report
2.9
Data Sources
2.9.1
About database roles
2.9.2
About Oracle Net Services
2.9.3
About user exits
2.9.4
About the Oracle Call Interface (OCI)
2.10
Debugging Tools
2.10.1
About the debugging process
2.10.2
About the PL/SQL Interpreter
2.10.3
About the Source pane
2.10.4
About debug commands in the PL/SQL Interpreter
2.10.5
About debug actions
2.10.5.1
About creating a debug action
2.10.6
About the current execution location
2.10.7
About the current scope location
2.10.8
About debug levels
2.10.9
About modifying code at runtime
3
How To...
3.1
Access Oracle Reports Documentation
3.1.1
Using the Oracle Reports online Help
3.1.2
Locating other documentation
3.2
Set Properties and Preferences
3.2.1
Displaying the Property Inspector
3.2.2
Setting report properties
3.2.3
Setting report preferences
3.2.4
Setting preferences for the Object Navigator
3.2.5
Setting properties for an ASCII (character-mode) report
3.2.6
Setting color palette preferences
3.2.7
Setting properties of multiple objects
3.2.8
Comparing the properties of one object to another
3.3
Perform Common Tasks
3.3.1
Connecting to a database
3.3.2
Opening a report
3.3.3
Saving a report
3.3.4
Copying a report
3.3.5
Renaming a report
3.3.6
Deleting a report
3.3.7
Archiving a report
3.3.8
Selecting and deselecting objects
3.3.8.1
Selecting single objects
3.3.8.2
Selecting multiple objects
3.3.8.3
Selecting objects owned by a frame
3.3.8.4
Selecting grouped objects
3.3.8.5
Selecting all objects in a report region
3.3.8.6
Selecting overlapped objects
3.3.8.7
Deselecting single objects
3.3.8.8
Deselecting multiple objects
3.3.9
Deleting an object
3.4
Work with the Object Navigator
3.4.1
Displaying a Report Editor view from the Object Navigator
3.4.2
Expanding and collapsing nodes
3.4.3
Searching for nodes
3.4.4
Changing Object Navigator views
3.4.5
Setting preferences for the Object Navigator
3.5
Work with Reports
3.5.1
Creating a report
3.5.2
Creating a multiquery group above report
3.5.3
Creating a nested matrix report
3.5.4
Creating a default layout for a report
3.5.5
Creating an additional report layout
3.5.6
Adding a title to a report
3.5.7
Adding a table of contents to a report
3.5.8
Adding index to a report
3.5.9
Creating an ASCII (character-mode) report
3.5.10
Preparing a multiplatform report
3.5.11
Preparing a report for translation into other languages
3.6
Work with Web Reports
3.6.1
Creating a Web report
3.6.2
Viewing the source code for a Web report
3.6.3
Adding report data to an existing Web page (HTML file)
3.6.4
Adding a report block to a Web page
3.6.5
Adding an image
3.6.6
Adding a graph
3.6.7
Editing a graph
3.6.8
Adding a graph hyperlink
3.6.9
Preparing a paper-based report for the Web
3.6.10
Adding Web links to paper-based reports
3.6.10.1
Using the user interface
3.6.10.2
Using PL/SQL
3.7
Run and Dispatch a Report
3.7.1
Running and dispatching a report from the user interface
3.7.2
Running a report from the command line
3.7.3
Running a report using a command file
3.7.4
Running a report to a remote Reports Server
3.7.5
Generating HTML or HTMLCSS output
3.7.6
Generating PDF output
3.7.7
Generating XML output
3.7.8
Generating RTF output
3.7.9
Generating text output
3.7.10
Generating delimited output
3.7.11
Generating spreadsheet output
3.7.12
Distributing a report to multiple destinations
3.7.13
Deploying a report
3.7.14
Changing orientation
3.7.15
Suppressing the Parameter Form
3.7.16
Viewing report output
3.7.16.1
Viewing the printable area
3.7.16.2
Displaying report output in the Paper Design view
3.7.16.3
Displaying report output in the Previewer
3.7.16.4
Displaying report output in your Web browser
3.7.16.5
Displaying individual pages of HTML report output
3.7.16.6
Scrolling and paging
3.7.16.7
Splitting the viewing region
3.7.16.8
Magnifying or reducing the output
3.7.17
Printing a report
3.7.17.1
Printing a report from the Paper Design or Paper Layout view
3.7.17.2
Printing a report from the Previewer
3.7.17.3
Printing a report from your Web browser
3.7.17.4
Printing a report on a preprinted form
3.7.17.5
Switching the printer tray
3.7.17.6
Printing a report on UNIX
3.7.18
E-mailing a report
3.8
Work with the Data Model
3.8.1
Creating a query
3.8.1.1
Creating a query: Report Wizard
3.8.1.2
Creating a query: Data Wizard
3.8.1.3
Creating a query: SQL Query tool
3.8.1.4
Creating a query: XML Query tool
3.8.1.5
Creating a query: JDBC Query tool
3.8.1.6
Creating a query: Text Query tool
3.8.1.7
Creating a query: Express Server Query tool
3.8.1.8
Creating a query: OLAP Query tool
3.8.1.9
Creating a query: REF CURSOR Query tool
3.8.2
Modifying a query
3.8.3
Using Query Builder
3.8.4
Selecting HTML tags from the database
3.8.5
Selecting an image from the database
3.8.6
Selecting an image URL from the database
3.8.7
Creating a break group
3.8.8
Creating a matrix (cross-product) group
3.8.9
Creating a data link
3.8.10
Creating or editing a formula column
3.8.11
Creating a summary column
3.8.12
Creating or editing a placeholder column
3.9
Work with the Report Layout
3.9.1
General Layout Objects
3.9.1.1
Creating a field object
3.9.1.2
Creating a frame or repeating frame
3.9.1.3
Creating a matrix object
3.9.1.4
Creating a barcode using a barcode font
3.9.1.5
Applying conditional formatting to a layout object
3.9.2
Text Objects
3.9.2.1
Creating a boilerplate object for text
3.9.2.2
Creating a boilerplate object for text that displays every other page
3.9.2.3
Creating a boilerplate text object for HTML tags
3.9.2.4
Editing text
3.9.2.5
Referencing a field in boilerplate text
3.9.2.6
Linking a boilerplate text object to a file
3.9.2.7
Linking an HTML text object to a file
3.9.2.8
Wrapping text in a field
3.9.2.9
Changing text attributes
3.9.2.10
Changing text attributes using PL/SQL
3.9.3
Page Numbers or Date/Time Stamps
3.9.3.1
Creating page numbers
3.9.3.2
Resetting page numbers
3.9.3.3
Creating a time or date stamp
3.9.4
Borders
3.9.4.1
Showing or hiding object borders
3.9.4.2
Changing object border attributes
3.9.4.3
Changing the current mode (Confine or Flex)
3.9.5
Anchors
3.9.5.1
Anchoring objects together
3.9.5.2
Viewing implicit anchors
3.9.5.3
Moving an anchor
3.9.6
Colors, Patterns, and Highlighting
3.9.6.1
Setting color palette preferences
3.9.6.2
Changing colors
3.9.6.3
Changing patterns
3.9.6.4
Changing colors and patterns using PL/SQL
3.9.6.5
Modifying the color palette
3.9.6.6
Importing or exporting a color palette
3.9.6.7
Highlighting a value
3.9.6.8
Highlighting a row
3.9.6.9
Alternating row colors
3.9.7
Format Masks
3.9.7.1
Specifying date and time format masks
3.9.7.2
Specifying number format masks
3.9.7.3
Applying a format mask to a numeric object
3.9.7.4
Applying a format mask to a date object
3.9.7.5
Adding a custom format mask
3.9.7.6
Changing the format mask for multiple fields
3.9.8
Graphic or Image Objects
3.9.8.1
Adding an image
3.9.8.2
Adding a graph
3.9.8.3
Editing a graph
3.9.8.4
Adding a graph hyperlink
3.9.8.5
Creating a drawing object
3.9.9
Page or Group Headers or Footers
3.9.9.1
Creating a text heading
3.9.9.2
Creating a heading that includes database values
3.9.9.3
Creating a group header or footer
3.9.10
Margin, Header Page, or Trailer Page Objects
3.9.10.1
Creating a margin object
3.9.10.2
Creating a header page or trailer page object
3.9.11
Move Objects
3.9.11.1
Moving multiple objects
3.9.11.2
Moving an object outside its parent
3.9.11.3
Adjusting parent borders automatically
3.9.11.4
Moving a column in report output
3.9.11.5
Offsetting detail objects in a group report
3.9.11.6
Aligning objects
3.9.11.7
Changing object layering
3.9.11.8
Rotating a boilerplate object
3.9.12
Resize Objects
3.9.12.1
Resizing objects
3.9.12.2
Making multiple objects the same size
3.9.12.3
Resizing object borders
3.9.13
Change Spacing
3.9.13.1
Changing columns labels or widths
3.9.13.2
Changing spacing within a text object
3.9.13.3
Changing the default layout spacing
3.9.13.4
Changing the spacing between all rows
3.9.13.5
Adding blank lines between groups of rows
3.9.14
Modify the Page Layout
3.9.14.1
Adjusting margins
3.9.14.2
Adding a page break
3.10
Work with Report Sections
3.10.1
Displaying a section layout view
3.10.2
Creating a default layout for a section
3.11
Work with Parameters and the Parameter Form
3.11.1
Using a pre-defined system parameter
3.11.2
Creating a user parameter
3.11.3
Creating a list of values (LOV) for a parameter
3.11.4
Validating a parameter value at runtime
3.11.5
Creating a default Parameter Form
3.11.6
Selecting parameters to include in the Runtime Parameter Form
3.11.7
Displaying the Parameter Form at runtime
3.11.8
Adding more pages to the Runtime Parameter Form
3.11.9
Passing parameters to reports running in batch mode
3.11.10
Creating an HTML Parameter Form header using PL/SQL
3.11.11
Creating an HTML Parameter Form footer using PL/SQL
3.11.12
Creating HTML Parameter Form input or select events
3.11.13
Changing HTML Parameter Form input to uppercase
3.12
Define a Template
3.12.1
Creating a template
3.12.2
Defining default template attributes
3.12.3
Defining override template attributes
3.12.4
Applying a template to a report
3.12.5
Formatting the report title in a template
3.12.6
Adding items and objects to a template
3.12.7
Modifying objects in the template margin
3.12.8
Modifying the color, pattern, or border of body objects in a template
3.12.9
Adding a template to the pre-defined templates list
3.12.10
Creating an HTML template for a report portlet
3.13
Use PL/SQL in a Report or Template
3.13.1
Using a built-in package
3.13.2
Working with the PL/SQL Editor
3.13.2.1
Defining PL/SQL
3.13.2.2
Searching and replacing text in a program unit
3.13.2.3
Editing a program unit
3.13.2.4
Inserting syntax into the PL/SQL Editor
3.13.3
Creating or editing report-level or template-level PL/SQL
3.13.3.1
Creating a local program unit
3.13.3.2
Creating a stored program unit
3.13.3.3
Deleting a program unit
3.13.3.4
Moving a program unit between client and database server
3.13.3.5
Creating a report trigger
3.13.3.6
Deleting a report trigger
3.13.3.7
Creating a database trigger
3.13.4
Creating or editing object-level PL/SQL
3.13.4.1
Creating or editing a format trigger
3.13.4.2
Creating or editing a group filter
3.13.4.3
Creating or editing a formula column
3.13.4.4
Creating a placeholder column
3.13.4.5
Changing colors and patterns using PL/SQL
3.13.5
Creating or editing an external PL/SQL library
3.13.5.1
Creating an external PL/SQL library
3.13.5.2
Adding a program unit to an open library
3.13.5.3
Editing a program unit in a PL/SQL library
3.13.5.4
Removing a program unit from a PL/SQL library
3.13.5.5
Attaching a PL/SQL library
3.13.5.6
Converting external PL/SQL libraries
3.13.6
Compiling and running program units
3.13.6.1
Compiling a single program unit
3.13.6.2
Compiling all program units
3.13.6.3
Compiling all uncompiled program units
3.14
Debug a Report
3.14.1
Debugging a report
3.14.2
Running a report in debug mode
3.14.3
Setting a breakpoint
3.14.4
Setting a debug trigger
3.14.5
Browsing debug actions
3.14.6
Editing a debug action
3.14.7
Disabling and enabling debug actions
3.14.8
Deleting a debug action
3.14.9
Running a program unit in the PL/SQL Interpreter
3.14.10
Inserting a Navigator pane in the PL/SQL Interpreter
3.14.11
Controlling program unit execution
3.14.12
Stepping through the code
3.14.13
Modifying code at runtime
3.14.14
Displaying the current scope location
3.14.15
Examining or changing local variables
3.14.16
Modifying application variables
3.14.17
Viewing subprogram references
3.14.18
Tracing report execution
3.14.19
Tracing report distribution
3.14.20
Tracing using the SQL TRACE function
3.14.20.1
Performing a user-level trace
3.14.20.2
Performing a system-level trace
3.15
Integrate with Other Products
3.15.1
Publishing a report as a portlet in OracleAS Portal
3.15.1.1
Running reports on OracleAS Portal as an item link
3.15.2
Accessing non-Oracle data sources
3.15.3
Integrating with the Oracle Express pluggable data source
3.16
Administer Reports Builder
3.16.1
Setting a database role
3.16.2
Converting from one format to another
3.16.3
Improving performance using SQL statements
3.16.4
Improving performance using WHERE clauses
4
Visual Index
4.1
Part 1: Building Basic Reports
4.1.1
Building a tabular report
4.1.2
Building a mailing label report
4.1.3
Building a form letter report
4.1.4
Building a master/master report
4.1.5
Building a summary report
4.2
Part 2: Building Group Reports
4.2.1
Building a single-query group report
4.2.2
Building a two-query group report
4.2.3
Building an across group report
4.2.4
Building a group left summary report
4.2.5
Building a group left formula report
4.3
Part 3: Building Reports with Special Formatting
4.3.1
Building a wrapped field report
4.3.2
Building a header and footer report
4.3.3
Building a header with database values report
4.3.4
Building a report with graphics, text, and color
4.3.5
Building a report that renumbers pages by repeating frame
4.3.6
Building an intermixed fields report
4.3.7
Building a report that suppresses labels
4.3.8
Building a conditional form letter report
4.3.9
Building a report with conditional highlighting
4.3.10
Building a report with dynamic graphics
4.4
Part 4: Building Matrix Reports
4.4.1
Building a matrix report
4.4.2
Building a nested matrix report
4.4.3
Building a matrix with group above report
4.5
Part 5: Building Reports for Business Cases
4.5.1
Building a time series calculations report
4.5.2
Deploying a paper report to Microsoft Excel output
4.5.3
Building a report with aggregate data
4.5.4
Building a check printing report with spelled-out cash amounts
4.5.5
Building a report using a preprinted form
4.5.6
Building an invoice report
4.5.7
Building a ranking report
4.5.8
Building a report with a simple table of contents and index
4.5.9
Building a report with a multilevel table of contents
4.5.10
Bursting and distributing a report
4.5.11
Building a report with multibyte characters for PDF output
4.6
Part 6: Building Reports with PL/SQL and Java
4.6.1
Building a PL/SQL report
4.6.2
Building a paper report with REF CURSORs
4.6.3
Building a simple Parameter Form for a JSP-based Web report
4.6.4
Building a report with a barcode
4.6.5
Building an accessible JSP-based Web report
4.7
Part 7: Building Reports with Pluggable Data Sources
4.7.1
Building a report with an XML pluggable data source
4.7.2
Building a report with a text pluggable data source
4.7.3
Building a report with an OLAP pluggable data source
4.7.4
Building a report using Oracle Express data
4.8
Summary
Part I Building Basic Reports
5
Building a Tabular Report
5.1
Prerequisites for this example
5.2
Use the Report Wizard to create a report
5.3
Summary
6
Building a Mailing Label Report
6.1
Prerequisites for this example
6.2
Use the Report Wizard to create a mailing label report
6.3
Add vertical spacing
6.4
Summary
7
Building a Form Letter Report
7.1
Prerequisites for this example
7.2
Use the Report Wizard to create a form letter report
7.3
Summary
8
Building a Master/Master Report
8.1
Prerequisites for this example
8.2
Create a new report manually
8.3
Use the Data Wizard to create two queries
8.4
Use the Report Wizard to layout the data
8.5
Use the Paper Layout view to add white space
8.6
Format a field
8.7
Summary
9
Building a Summary Report
9.1
Prerequisites for this example
9.2
Create a data model and a group above layout
9.3
Format fields
9.4
Examine the summary column properties (optional)
9.5
Summary
Part II Building Group Reports
10
Building a Single-Query Group Report
10.1
Prerequisites for this example
10.2
Group report with one break column
10.2.1
Create a data model with a break group and group left layout
10.2.2
Format a field
10.2.3
Use the Property Inspector to add white space
10.3
Group report with two break columns
10.3.1
Modify the data model
10.3.2
Redefault the layout
10.4
Group report with two break groups
10.4.1
Modify the data model
10.4.2
Redefault the layout
10.5
Summary
11
Building a Two-Query Group Report
11.1
Prerequisites for this example
11.2
Create a new report manually
11.3
Create a data model with a data link
11.4
Use the Report Wizard to layout the data
11.5
Format a field
11.6
Summary
12
Building an Across Group Report
12.1
Prerequisites for this example
12.2
Create two queries
12.3
Create the default layout
12.4
Run your report to paper
12.5
Summary
13
Building a Group Left Summary Report
13.1
Prerequisites for this example
13.2
Create a new report manually
13.3
Create a data model with a data link
13.4
Use the Paper Layout view to create two layouts
13.5
Merge the two layouts
13.6
Format fields
13.7
Summary
14
Building a Group Left Formula Report
14.1
Prerequisites for this example
14.2
Use the Report Wizard to create a simple report
14.3
Create two formula columns
14.3.1
Create a formula column to calculate the tax
14.3.2
Create a formula column that calculates customer order totals
14.3.3
Add the formula columns to the report layout
14.4
Summary
Part III Building Reports with Special Formatting
15
Building a Wrapped Field Report
15.1
Prerequisites for this example
15.2
Create a query in the Data Model view
15.3
Create three summary columns
15.4
Create the default layout using the Report Wizard
15.5
Modify the layout of the report
15.6
Run your report to paper
15.7
Summary
16
Building a Header and Footer Report
16.1
Prerequisites for this example
16.2
Create a data model and a group left layout
16.3
Move a summary
16.4
Add a page heading
16.5
Add white space and format fields
16.6
Summary
17
Building a Header with Database Values Report
17.1
Prerequisites for this example
17.2
Create a data model and a group left layout
17.3
Add summary columns for the header data
17.4
Add a page heading
17.5
Summary
18
Building a Report with Graphics, Text, and Color
18.1
Prerequisites for this example
18.2
Create a simple report definition
18.3
Modify the report in the Paper Layout view
18.3.1
Add a border around the report
18.3.2
Change the font size and style
18.3.3
Add bullets to your report
18.3.4
Display a line between each record
18.3.5
Add a title to your report
18.4
Summary
19
Building a Report that Renumbers Pages by Repeating Frame
19.1
Prerequisites for this example
19.2
Create a data model and a group above layout
19.3
Add a second query
19.4
Redefault the layout
19.5
Set properties and format fields
19.6
Create new fields
19.7
Reference fields
19.8
Summary
20
Building an Intermixed Fields Report
20.1
Prerequisites for this example
20.2
Create a data model and a layout
20.3
Add a formula column
20.4
Add a field
20.5
Remove a redundant field
20.6
Suppress redundant values
20.7
Summary
21
Building a Report that Suppresses Labels
21.1
Prerequisites for this example
21.2
Create the data model with two linked queries
21.3
Create a formula column and a summary column
21.3.1
Create a formula column in the detail query
21.3.2
Create a summary column in the master query
21.4
Create the report layout
21.4.1
Create the initial layout of your report
21.5
Add a format trigger to suppress labels
21.6
Add text to display when no records display
21.7
Summary
22
Building a Conditional Form Letter Report
22.1
Prerequisites for this example
22.2
Create the data model and layout
22.3
Add additional text
22.4
Add logic for text
22.5
Summary
23
Building a Report with Conditional Highlighting
23.1
Prerequisites for this example
23.2
Create a basic tabular report
23.3
Add conditional formatting to the report
23.4
Examine the conditional format trigger code
23.5
Summary
24
Building a Report with Dynamic Graphics
24.1
Prerequisites for this example
24.1.1
Access to the data source and installing the Pictures table
24.1.2
Graphics for the report
24.2
Create the data model with two linked queries
24.3
Create the layout of the report
24.3.1
Create the initial layout of your report using the Report Wizard
24.3.2
Modify the layout of your report
24.4
Run your report to paper
24.5
Summary
Part IV Building Matrix Reports
25
Building a Matrix Report
25.1
Prerequisites for this example
25.2
Create a single-query matrix
25.3
Create a multiple-query matrix
25.3.1
Create a new report manually
25.3.2
Create a data model with a cross product and a data link
25.3.3
Create the layout with the Report Wizard
25.4
Add summaries to the single-query matrix
25.5
Format monetary values
25.6
Add zeroes in place of blanks
25.7
Add a grid
25.8
Summary
26
Building a Nested Matrix Report
26.1
Prerequisites for this example
26.2
Create a single-query matrix
26.3
Create a multiple-query matrix
26.3.1
Create a new report manually
26.3.2
Create a data model with a cross product and data links
26.3.3
Create the layout with the Report Wizard
26.4
Create a multiple-query matrix with a break
26.4.1
Create a new report manually
26.4.2
Create a data model with a cross product and data links
26.4.3
Create the layout with the Report Wizard
26.5
Format monetary values
26.6
Summary
27
Building a Matrix with Group Above Report
27.1
Prerequisites for this example
27.2
Create a matrix group data model and layout
27.3
Add labels and lines for summaries
27.4
Add space between groups
27.5
Create a Web layout
27.6
Summary
Part V Building Reports for Business Cases
28
Building a Time Series Calculations Report
28.1
Prerequisites for this example
28.2
Create a query and the layout
28.3
Modify the Web source of your JSP report
28.4
Summary
29
Building a Report for Spreadsheet Output
29.1
Prerequisites for this example
29.2
Create a query and the layout
29.3
Modify the Web source of your JSP report
29.4
Modify your JSP report to display in Microsoft Excel
29.5
Summary
30
Building a Report with Aggregate Data
30.1
Prerequisites for this example
30.2
Create a query and the layout
30.3
Modify the Web source of your JSP report
30.4
Summary
31
Building a Check Printing Report with Spelled-Out Cash Amounts
31.1
Prerequisites for this example
31.2
Create a report using the Report Wizard
31.3
Create a formula column that returns the spelled-out cash amounts
31.3.1
Create a PL/SQL function
31.3.2
Create a formula column in your data model
31.4
Create a query that will return the items in the order
31.5
Import a check image and arrange fields for printing
31.5.1
Rearrange the layout objects
31.5.2
Import the blank check image
31.5.3
Set up the check printing fields
31.5.4
Rearrange the new fields according to the blank check image
31.5.5
Modify the look and feel of the check
31.6
Create a check stub with payment information and order details
31.6.1
Create a check stub in the Paper Design view
31.6.2
Add order details to the check stub
31.7
Summary
32
Building a Report Using a Preprinted Form
32.1
Prerequisites for this example
32.2
Manually create the data model for your report
32.2.1
Create the queries
32.2.2
Modify your data model
32.3
Create the layout for your report
32.3.1
Set up your report layout
32.3.2
Create an address label for your form
32.3.3
Add the order item details to your report
32.3.4
Adjust the layout and add summaries
32.4
Format your report in the Paper Design view
32.5
Add page numbers (optional)
32.6
Summary
33
Building an Invoice Report
33.1
Prerequisites for this example
33.2
Create a new report manually
33.3
Create a data model with a data link
33.4
Create summary and formula columns
33.5
Prepare the layout
33.6
Insert invoice information
33.7
Summary
34
Building a Ranking Report
34.1
Prerequisites for this example
34.2
Create a data model and tabular layout
34.3
Create ranking logic for top number of customers
34.4
Add a layout object for a parameter
34.5
Create a Parameter Form
34.6
Add a percentage ranking
34.7
Summary
35
Building a Paper Report with a Simple Table of Contents and Index
35.1
Prerequisites for this example
35.2
Create a simple table of contents
35.2.1
Create a table in the database to hold the TOC data
35.2.2
Create a group above report
35.2.3
Create an After Parameter Form trigger and a format trigger
35.2.3.1
Create an After Parameter Form trigger
35.2.3.2
Create a format trigger
35.2.4
Create a second query in the data model
35.2.5
Create a report block to display the table of contents
35.2.6
Run your simple table of contents report to paper
35.3
Create an index
35.3.1
Create a table in the database to hold the information for the index
35.3.2
Create a format trigger
35.3.3
Add a query to the data model
35.3.4
Create a report block to display the index in the Trailer section
35.3.5
Run your report to paper
35.4
Summary
36
Building a Paper Report with a Multilevel Table of Contents
36.1
Prerequisites for this example
36.2
Create a table in the database to hold the TOC data
36.3
Create an After Parameter Form trigger and a format trigger
36.3.1
Create an After Parameter Form trigger
36.3.2
Create a format trigger
36.4
Create a second query in the data model
36.5
Create a report block to display the table of contents
36.6
Run your multilevel table of contents report to paper
36.7
Summary
37
Bursting and Distributing a Report
37.1
Prerequisites for this example
37.2
Set up an existing report for bursting
37.3
Edit the distribution XML definition
37.4
Run the report
37.5
Summary
38
Building a Report with Multibyte Characters for PDF Output
38.1
Prerequisites for this example
38.2
Create the query and paper layout for a multibyte report
38.3
Display multibyte characters in the report
38.4
Create a PDF document of your report
38.5
Summary
Part VI Building Reports with PL/SQL and Java
39
Building a Report that Includes PL/SQL
39.1
Prerequisites for this example
39.2
Create a new PL/SQL library
39.3
Create the report definition
39.3.1
Create a query
39.3.2
Create a formula column that calculates bonuses
39.3.3
Create a report-level function that calculates total compensation
39.3.4
Create a second formula column for total compensation
39.4
Create the report layout using the Report Block Wizard
39.5
Add vertical space between records
39.5.1
Create a user parameter
39.5.2
Create a summary column that counts the number of records
39.5.3
Modify the layout
39.5.4
Create a format trigger
39.6
Run your report to paper
39.7
Summary
40
Building a Paper Report with REF CURSORs
40.1
Prerequisites for this example
40.2
Define a REF CURSOR type
40.3
Create a REF CURSOR query
40.4
Refine the data model
40.5
Create links between REF CURSOR queries
40.6
Add summary columns
40.7
Create a layout
40.8
Move the SELECT statements into packages
40.9
Move the packages into a library
40.10
Summary
41
Building a Simple Parameter Form for a JSP-based Web Report
41.1
Prerequisites for this example
41.2
Create a Parameter Form in HTML
41.3
Modify the HTML Parameter Form in Reports Builder
41.3.1
Create a data model manually for the Parameter Form
41.3.2
Create a dynamic LOV in the Parameter Form
41.3.3
Run the Parameter Form report to the Web
41.4
Set up the target report
41.5
Deploy the JSP Parameter Form and the target report
41.6
Summary
42
Building a Report with a Barcode
42.1
Prerequisites for this example
42.1.1
Update the REPORTS_CLASSPATH environment variable
42.2
Create a barcode report for paper
42.2.1
Import the Java classes into Reports Builder
42.2.2
Create a package to store your information
42.2.3
Create a Before Report trigger
42.2.4
Create a query in the Data Model view
42.2.5
Create a formula column to retrieve the barcode image
42.2.6
Create a formula column that returns the order total
42.2.7
Create a layout for your report
42.3
Create a barcode report for the Web
42.3.1
Create a query in an existing HTML file
42.3.2
Create three formula columns in your data model
42.3.3
Initialize the barcode JavaBean and set its properties
42.3.4
Run your report to the Web
42.4
Summary
43
Building an Accessible JSP-based Web Report
Part VII Building Reports with Pluggable Data Sources
44
Building a Report with an XML Pluggable Data Source
44.1
Prerequisites for this example
44.2
Create a report manually with SQL and XML queries
44.2.1
Create a SQL query for your new report
44.2.2
Create an XML query to access your XML data source
44.2.3
Create a data link between two queries
44.2.4
Create a layout for your report using the Report Wizard
44.2.5
Apply alternating row colors to your report
44.2.6
Filter your XML data using a group filter
44.3
Run your report to paper
44.4
Summary
45
Building a Report with a Text Pluggable Data Source
45.1
Prerequisites for this example
45.2
Set up the textpds.conf file
45.3
Use the Report Wizard to create a report
45.4
Summary
46
Building a Report with an OLAP Pluggable Data Source
46.1
Prerequisites for this example
46.2
Create a new report based on OLAP data
46.2.1
Create a new simple report
46.2.2
Define the OLAP data source connection in the Connection Editor
46.2.3
Specify connection details in the OLAP Connection tabbed page
46.2.4
Define the query to access OLAP data using the Query Wizard
46.2.5
Specify row, column, and cell field details for a matrix report using the Report Wizard
46.3
Format the report in the Paper Design view
46.4
Run your report to paper
46.5
Summary
47
Building a Report Using Oracle Express Data
47.1
Prerequisites for this example
47.2
Define the Express query using the Report Wizard
47.3
Refine the Express query
47.4
Add summary columns and custom measures to the data model
47.4.1
Rename data objects
47.4.2
Create summary columns
47.4.3
Create a custom measure
47.5
Enhance the report layout
47.5.1
Insert summary fields in the report
47.5.2
Insert the custom measure field into the report
47.5.3
Sort dimension values
47.5.4
Make format changes in the Paper Design view
47.6
Summary
A
Tool Palette and Toolbar Reference
A.1
Main Toolbar
A.2
Data Model View Tool Palette
A.3
Paper Layout View Tool Palette
Glossary
Index
