Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)

Part Number B32122-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

33 Building an Invoice Report

In this chapter, you will learn about reports that display output on invoices. By following the steps in this chapter, you can generate the report output shown in Figure 33-1.

Figure 33-1 Invoice report output

Description of Figure 33-1 follows
Description of "Figure 33-1 Invoice report output"



Many of the concepts in this example are used in the following example reports:

Data Relationships

The data for this report is fetched using two queries, linked together in a master/detail relationship. You will also define a break and two summaries.


This layout is similar to the layout for the preprinted form report, but in this case you will also link to a TIFF image of your form to use as a guide while adjusting the positions of several fields.

Example Scenario

In this example, you will create a report that prints an invoice for each customer, listing the following information:

You will also learn how to import an image of a preprinted form (in this case, a blank invoice image) and use the tools in the Paper Layout view to print your report on this form.

As you build this example report, you will:

To see a sample invoice report, open the examples folder named invoice, then open the Oracle Reports example named invoice.rdf. For details on how to open it, see "Accessing the Example Reports" in the Preface.