5 Building a Tabular Report

In this chapter, you will learn about tabular reports, the most basic report style. By following the steps in this chapter, you can generate the report output shown in Figure 5-1.

Figure 5-1 Tabular report output

Description of Figure 5-1 follows
Description of "Figure 5-1 Tabular report output"


A tabular report is the most basic type of report you can build. The report output is organized in a multicolumn, multirow format, with each column corresponding to a column in the database table. In this example, the column labels Department Id, Department Name, Manager Id, and Location Id are derived from the columns in your SQL SELECT statement, but you can modify column labels as you wish.

Data Relationships


Example Scenario

As you build this example report, you will:

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