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

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

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3.6 Part 6: Building Reports with PL/SQL and Java

This part of the manual explains how you can build reports using PL/SQL and Java.

3.6.1 Building a PL/SQL report

In this example, you will learn how to use an external PL/SQL library and PL/SQL within a report to modify formatting and calculate the total compensation for each employee. In the sample output below, notice the spacing between records (for example, between the record for Alexander Khoo and the record for Alexis Bull). This space is not due to a break; it is the result of using a PL/SQL procedure in a format trigger.

Figure 3-37 Final output of the PL/SQL report example

Description of Figure 3-37 follows
Description of "Figure 3-37 Final output of the PL/SQL report example"

For more information on building this example, refer to Chapter 40, "Building a Report that Includes PL/SQL".

3.6.2 Building a paper report with REF CURSORs

In this example, you will learn how to use Reports Builder's features for using REF CURSORs. To build this paper report, you will use the Data Model view to create a multiquery data model, and then use the Report Wizard to create the report layout. You will make fairly extensive manual refinements in the Data Model view.

Figure 3-38 Final output for the REF CURSORs example

Description of Figure 3-38 follows
Description of "Figure 3-38 Final output for the REF CURSORs example"

For more information on building this example, refer to Chapter 41, "Building a Paper Report with REF CURSORs".

3.6.3 Building a simple Parameter Form for a JSP-based Web report

This example is designed to teach you how to build a simple JSP Parameter Form for a Web report. You will build a simple form in HTML, then create a JSP Parameter Form based on a data model in Reports Builder. You will then learn how to link the Parameter Form with an existing JSP-based Web report, then deploy and test both the JSP Parameter Form and the Web report through your browser.

Figure 3-39 JSP Parameter Form

Description of Figure 3-39 follows
Description of "Figure 3-39 JSP Parameter Form"

Figure 3-40 JSP-based Web report based on a user parameter

Description of Figure 3-40 follows
Description of "Figure 3-40 JSP-based Web report based on a user parameter"

For more details on building this example, refer to Chapter 42, "Building a Simple Parameter Form for a JSP-based Web Report".

3.6.4 Building a report with a barcode

In this example, you will build a report using the barcode Java bean in Oracle Reports. You will build two reports: one for paper and one for the Web. The paper report shows an invoice for a single customer who has ordered multiple items from a company. The barcode indicates the tracking information for the order.

Figure 3-41 Final output of the barcode report with paper layout

Description of Figure 3-41 follows
Description of "Figure 3-41 Final output of the barcode report with paper layout"

Figure 3-42 Final output of the barcode report with Web layout

Description of Figure 3-42 follows
Description of "Figure 3-42 Final output of the barcode report with Web layout"

For more details on building this example, refer to Chapter 43, "Building a Report with a Barcode".

3.6.5 Building an accessible JSP-based Web report

In this example, you will use the properties in Oracle Reports to produce a JSP-based Web report that is accessible using assistive technology. You will learn how to modify an existing paper-based report to be accessible.

For more information on building this example, refer to Chapter 44, "Building an Accessible JSP-based Web Report".

Note:

No sample output is available for this report.