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

29 Building a Report for Enhanced Spreadsheet Output

In this chapter, you will learn about Enhanced Spreadsheet reports. Oracle Reports generates spreadsheet output using the ENHANCEDSPREADSHEET format. The ENHANCEDSPREADSHEET output format is new in Oracle Reports 11g Release 2 (11.1.2) and provides the following benefits:

For more information about Enhanced spreadsheet output, refer to Section 2.8.13, "About Enhanced Spreadsheet output".

By completing the steps in this chapter, you can generate the Enhanced Spreadsheet report output, as shown in Figure 29-1.

Figure 29-1 Enhanced Spreadsheet report output

Description of Figure 29-1 follows
Description of "Figure 29-1 Enhanced Spreadsheet report output"

Concepts

Example Scenario

In this example, you will generate a report to Microsoft Excel output. The output is generated after integrating the paper layout into a Web layout by modifying the Web source of your report.

As you build this example report, you will:

To see a sample report, open the examples folder named papertoexcel, then open the Oracle Reports example named mypaperreport.rdf. For details on how to open it, see "Accessing the Example Reports" in the Preface. The example files used in this chapter are listed and described in Table 29-1.

Table 29-1 Example Report Files

File Description

papertoexcel\mypaperreport.rdf

The sample paper report. Running this RDF in Reports Builder will display the result of your paper report in the Paper Design view.

papertoexcel\myexcelreport.jsp

This JSP-based Web report contains the modifications to the paper report you will make in Reports Builder.

papertoexcel\papertoexceldata_code.txt

The SQL for the query you need to enter.