|Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)
Part Number B32122-01
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.
Figure 30-1 Aggregate data report output
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.