17 Building a Header with Database Values Report

In this chapter, you will learn about reports with headers that include values queried from the database. By following the steps in this chapter, you can generate the report output shown in Figure 17-1.

Figure 17-1 Group left report output with database values in header

Description of Figure 17-1 follows
Description of ''Figure 17-1 Group left report output with database values in header''

Concepts

In this example report, both the first and last department numbers found on each page are displayed in the page header.

Layout

This report uses one query and two groups. You'll also create two summary columns to provide the values for the header fields. To ensure unique field values for each page, you'll compute the values using the First and Last functions. The First function will return the first database value selected for a group, page, or report, and the Last function will return the last database value selected for a group, page, or report.

Layout

This report uses the default group left format with no modifications.

Example Scenario

In this example, you will create a report that displays and summarizes employee data by department. To make the report more readable, you decide to add a header to each page that indicates which departments appear on the page.

As you build this example report, you will:

To see a sample header with database values report, open the examples folder named headingdb, then open the Oracle Reports example called headingdb.rdf. For details on how to access it, see "Accessing the Example Reports" in the Preface.