Skip Headers
Oracle Reports Building Reports
10
g
(9.0.4)
Part Number B10602-01
Home
Index
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Intended Audience
Documentation Accessibility
Accessibility of Code Examples in Documentation
Structure
Accessing the example reports
Accessing the data sources
Other resources
1 Basic Concepts
1.1 Reports Builder
1.2 Reports
1.3 Report Styles
1.4 Wizards
1.5 The Object Navigator
1.6 The Report Editor
1.7 Data Model Objects
1.8 Layout Objects
1.9 Parameter Form Objects
1.10 The Property Inspector
1.11 Runtime Views
1.12 Executables
2 Advanced Concepts
2.1 Reports
2.2 Web Reports
2.3 Data Model Objects
2.4 Layout Objects
2.5 Parameter Form Objects
2.6 PL/SQL
2.7 Templates
2.8 Output Formats and Capabilities
2.9 Data Sources
2.10 Debugging Tools
3 How To...
3.1 Access Oracle Reports Documentation
3.2 Set Properties and Preferences
3.3 Perform Common Tasks
3.4 Work with the Object Navigator
3.5 Work with Reports
3.6 Work with Web Reports
3.7 Run and Dispatch a Report
3.8 Work with the Data Model
3.9 Work with the Report Layout
3.10 Work with Report Sections
3.11 Work with Parameters and the Parameter Form
3.12 Define a Template
3.13 Use PL/SQL in a Report or Template
3.14 Debug a Report
3.15 Integrate with Other Products
3.16 Administer Reports Builder
4 Visual Index
4.1 Part 1: Building Basic Reports
4.2 Part 2: Building Group Reports
4.3 Part 3: Building Reports with Special Formatting
4.4 Part 4: Building Matrix Reports
4.5 Part 5: Building Reports for Business Cases
4.6 Part 6: Building Reports with PL/SQL and Java
4.7 Part 7: Building Reports with Pluggable Data Sources
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.3 Group report with two break columns
10.4 Group report with two break groups
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.4 Summary
Part III Building Reports with Special Formatting
15 Building a Wrapped Field Report
15.1 Prequisites 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 Adding white space and formatting values
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 Prequisites for this example
18.2 Create a simple report definition
18.3 Modify the report in the Paper Layout view
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.4 Create the report layout
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.2 Create the data model with two linked queries
24.3 Create the layout of the report using the Report Wizard
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.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.4 Create a multiple-query matrix with a break
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 with Aggregate Data
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 Summary
30 Building a Check Printing Report with Spelled-Out Cash Amounts
30.1 Prerequisites for this example
30.2 Create a report using the Report Wizard
30.3 Create a formula column that returns the spelled-out cash amounts
30.4 Create a query that will return the items in the order
30.5 Import a check image and arrange fields for printing
30.6 Create a check stub with payment information and order details
30.7 Summary
31 Building a Report Using a Pre-Printed Form
31.1 Prerequisites for this example
31.2 Manually create the data model for your report
31.3 Create the layout for your report
31.4 Format your report in the Paper Design view
31.5 Add page numbers (optional)
31.6 Summary
32 Building an Invoice Report
32.1 Prerequisites for this example
32.2 Create a new report manually
32.3 Create a data model with a data link
32.4 Create summary and formula columns
32.5 Prepare the layout
32.6 Insert invoice information
32.7 Summary
33 Building a Ranking Report
33.1 Prerequisites for this example
33.2 Create a data model and tabular layout
33.3 Create ranking logic for top number of customers
33.4 Add a layout object for a parameter
33.5 Create a Parameter Form
33.6 Add a percentage ranking
33.7 Summary
34 Building a Paper Report with a Simple Table of Contents and Index
34.1 Prerequisites for this example
34.2 Create a simple table of contents for a large report
34.3 Create an index for your report
34.4 Summary
35 Building a Paper Report with a Multilevel Table of Contents
35.1 Prerequisites for this example
35.2 Create a table in the database to hold the TOC data
35.3 Create an After Parameter Form trigger and format trigger
35.4 Create a layout for the table of contents
35.5 Summary
36 Bursting and Distributing a Report
36.1 Prerequisites for this example
36.2 Set up an existing report for bursting
36.3 Edit the distribution XML definition
36.4 Run the report
36.5 Summary
Part VI Building Reports with PL/SQL and Java
37 Building a PL/SQL Report
37.1 Prerequisites for this example
37.2 Create a new PL/SQL library
37.3 Create the report definition
37.4 Create the report layout using the Report Block Wizard
37.5 Add vertical space between records
37.6 Run your report to paper
37.7 Summary
38 Building a Paper Report with Ref Cursors
38.1 Prerequisites for this example
38.2 Define a ref cursor type
38.3 Create a ref cursor query
38.4 Refine the data model
38.5 Create links between ref cursor queries
38.6 Add summary columns
38.7 Create a layout
38.8 Move the SELECT statement into a package
38.9 Move the packages into a library
38.10 Summary
39 Building a Simple Parameter Form for a JSP-based Web Report
39.1 Prerequisites for this example
39.2 Create a Parameter Form in HTML
39.3 Modify the HTML Parameter Form in Reports Builder
39.4 Set up the target report
39.5 Deploy the JSP report and Parameter Form
39.6 Summary
40 Building a Report with a Barcode
40.1 Prerequisites for this example
40.2 Create a barcode report for paper
40.3 Create a barcode report for the Web
40.4 Summary
Part VII Building Reports with Pluggable Data Sources
41 Building a Report with an XML Pluggable Data Source
41.1 Prerequisites for this example
41.2 Create a report manually with SQL and XML queries
41.3 Run your report to paper
41.4 Summary
42 Building a Report with a Text Pluggable Data Source
42.1 Prerequisites for this example
42.2 Set up the textpds.conf file
42.3 Use the Report Wizard to create a report
42.4 Summary
43 Building a Report Using Oracle Express Data
43.1 Prerequisites for this example
43.2 Create an Express report with the Report Wizard
43.3 Refine the Express query
43.4 Add summary columns and custom measures to the data model
43.5 Enhance the report layout
43.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
Copyright © 2002, 2003 Oracle Corporation.
All Rights Reserved.
Home
Index