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"


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


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


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


The SQL for the query you need to enter.