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