In this chapter, you will learn about reports that include aggregate data, based on value ranges. By following the steps in this chapter, you can generate the report output shown in Figure 30-1.
In a report that aggregates, or collects, data within ranges, values from the database are retrieved and formatted based on an aggregate range that you define. You can even use parameters to specify the range over which the data should be collected.
This report uses two "functions" in its SELECT
statement to specify the aggregate range. The functions are (FLOOR(SAL/1000))*1000)
, which calculates the lowest salary, and (CEIL*((SAL+1)/1000) * 1000)
, which calculates the highest salary. The columns that receive the values of these functions are placed into a break group to produce the control break format of this example report.
This report uses the Group Left layout style.
In this example, you will build both a paper and JSP-based Web report that collects and displays names of all employees whose salaries fall within the range of 0 to 999, then collects and displays all employees whose salaries fall within the range of 1000 to 1999, and so on. You will be able to modify this report to display any aggregate range you need.
As you build this example report, you will:
Create a Query and the Layout using the Report Wizard to create a data model and layout for both the paper and Web reports.
Modify the Web Source of Your JSP Report to generate the JSP-based Web report.
To see a sample report that aggregates data within ranges, open the examples folder named aggregatingdata
, then open the Oracle Reports example named aggregatingdata.rdf
. For details on how to open it, see "Accessing the Example Reports" in the Preface.