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
In this example report, both the first and last department numbers found on each page are displayed in the page header.
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.
This report uses the default group left format with no modifications.
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:
Add a Page Heading that repeats on all pages with database values.
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.