36 Building a Paper Report with a Multilevel Table of Contents

In this chapter, you will learn about reports that include a multilevel table of contents.


Generating a table of contents is not supported for matrix reports.

By following the steps in this chapter, you can generate the report output shown in Figure 36-1 and Figure 36-2.

Figure 36-1 Multilevel table of contents

Description of Figure 36-1 follows
Description of "Figure 36-1 Multilevel table of contents"

Figure 36-2 Main category with sub-category sample page in the report

Description of Figure 36-2 follows
Description of "Figure 36-2 Main category with sub-category sample page in the report"


For more information on the SRW built-in package in Oracle Reports, refer to the Oracle Reports online Help.

Example Scenario

In this example, you have a large paper catalog that lists all the clothing products a company sells. This catalog simply lists all the items in a simple report. Since the product line has become much larger, the catalog report now exceeds 700 pages. You will create a multilevel table of contents that sorts the clothing by department (for example, Boys, Girls), then lists each item under each category.

As you build this example report, you will:

To see a sample report with a multilevel table of contents, open the examples folder named multileveltoc, then open multilevel_toc.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 36-1.

Table 36-1 Example report files

File Description


The source file that contains a basic paper layout and data model for your report.


The final RDF version of the report with a multilevel table of contents.


The various SQL statements you will use in this report.