A script-enabled browser is required for this page to function properly.

About nested matrix reports

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).

See also

Creating a nested matrix report

About matrix objects

About matrix reports

About matrix with group reports

Creating a report

Creating a matrix object

Creating a matrix (cross-product) group