A nested matrix report is a matrix report in which at least one parent/child relationship appears within the matrix grid..
A nested matrix report has more than two dimensions; therefore, it has multiple dimensions going across or down the page. For example, look at the report in About matrix with group reports. Notice that for each year there is a nested list of related departments. Also notice that the list of jobs (the across values) appears only once. Because the job values appear only once, a summary of each category of jobs can be made to line up with the values it summarizes.
Note: In a nested matrix report, where you create a matrix query that has a child matrix query, the fields on which you join should be separated into a separate group in your master matrix. Otherwise, on some platforms, only the first group prints.
For a detailed example, see the chapter "Building a Nested Matrix Report"
in the Oracle Reports Building Reports manual, available on the Oracle
Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html
).
Creating a nested matrix report
About matrix with group reports
Creating a matrix (cross-product) group
Copyright © 1984, 2005, Oracle. All rights reserved.